-
Error 313: The optimizer could not find a unique index which it could use to ...
I've got a stored procedure which runs fine if I just run it in ISQL.
When I tried to create query subject with in within Cognos, it gave me the following error: "The optimizer could not find a unique index which it could use to perform an isolation level 0 scan on table <temp table name>."
I have created a unique index on my tempdb table. I have also tried using the HOLDLOCK keyword on my select statements. I have also tried setting the isolation level to 3, all to no avail. And all of the above at one. I am thoroughly stumped.
Does anyone have any ideas how to breakthrough on this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|