Guys,
correct me if I am wrong but it seems to me that the index is scanned to avoid sorting, not for selectivity.
The index seems to be primary key index on NGID and has nothing to deal with the predicates.
Please buid an index on NGPROJGUID and I belive it will improve drastically
Regards
Boris




Reply With Quote