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 |
|
d17may
Starting Member
7 Posts |
 Posted - 2006-06-09 : 01:41:21
|
| I have table which has one datetime field .i want to index that field .this field is not unique .is it possible to index that field.data is inserted datewise .i have to generate reports from this table .query for reports fetch data between two dates and sort it .what kind of indexing is most appropriate for this situation.Thanks d17may |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-09 : 01:48:33
|
| If possible, create a clustered index on the datetime fieldcreate clustered index cix_table1 on table1 (field1)otherwise, just drop "clustered" |
 |
|
|
|
|
|
Indexing problem