var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to create index (Case when)
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]
Thx in Adv
Use 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