User defined statistics

Question

Hi there!!

I have a table which has just one row say for current date. this row is daily updated with current date. Now my all the SPs some 1000 uses this table to extract current date.

Now i want to know how beneficial would it be if i create a statistic on this table with the current date column something like stats on (DateKey, Date)

Structure of d table: CREATE TABLE TblDate ( DateKey NOT NULL, DATE DATETIME );

thanks!!

---

Rahul Kumar, MCTS, India, http://sqlserversolutions.blogspot.com/

Answer 1

There will not be any gain as you sais this table contains only one row.

The goal for using statistics in SQL Server is to allow the optimizer to get good cardinality estimates so it can find good query plans.

Consider creating statistics with the CREATE STATISTICS statement when any of the following applies:

• The Database Engine Tuning Advisor suggests creating statistics.
• The query predicate contains multiple correlated columns that are not already in the same index.
• The query selects from a subset of data.
• The query has missing statistics.

Please refer Determining When to Create Statistics

 

---

Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!

Answer 2

Rahul,

As u mentioned that table has only one row , so there will not any proformance gain on creating a statistics or indexes.

 

---

Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

Answer 3

Since you said there will be one row there wont be any performane gain by adding a key