Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2011-03-23 : 03:05:45
|
| hello everybody, Is it a good practice to create index on a column of datetime datatype.I use these datetime columns in lot of queries with search criteria based on the datetime columns.Thanx in advance |
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-03-23 : 05:26:58
|
| It is good practice to index columns which are frequent search criteria. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-03-27 : 01:24:56
|
| its a good practise. Its not datatype that matters but its the usage and selectivity of value that matters when chosing data for an index.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
index on datatime columns