I have an indexed table of 1,750,000 rows which gives excellent performance when doing a database query on a column which has a secondary non-unique index. When I try to perform a similar query in a stored procedure via a cursor however, it does a full table scan on every query. Is there a way that I can force it to use the index?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.