SQL Server Performance Forum – Threads Archive

different results from index

Hi,
i have a query like this:
select * from table where c_1 = 1 and (c_2=1 or c_3=1) i have an index on c_1, c_2, c_3 the query returns different results. (when i run this query i get 600 rows. after a few seconds i run it again and take 1800 rows.)
after this problem i delete the index then it is ok. is this a bug? i use sql server 2000

Did you try having same index after drop it?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

yes i created same index i found a bug fixed in sp4 i think that is the problem . because c_* are bit columns

the url of the bug
http://support.microsoft.com/kb/824018

Thanks, first time I see it.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>