How to create index when there is a SQL statement like
Select count(1) as [Total],
sum(Case when Field1 < Field2 then 1 else 0 End) as [Selected]
from Table1
Thx in Adv
XLDBUse one index on each column ( field 1 field 2 ) ...use nonclustered for each
however, if table is small ( say less than 1000 row s ) SQL probably wont use indexes..it will scan whole table.|||the table has 2 million records|||actually, there are 2 similar tables that i use the query on...
the table with 2 million records is taking 57 seconds
the table with 40,000 records is taking 1 second
there is only 1 index on "Field1" in "Case When" statement
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment