Results 1 to 2 of 2

Thread: Error 313: The optimizer could not find a unique index which it could use to ...

Hybrid View

  1. #1
    Join Date
    Oct 2024
    Posts
    2

    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?

  2. #2
    Join Date
    Oct 2024
    Posts
    2
    NM, I got it! I changed the table from tempdb..tmp_chks to #tmp_chks and that seemd to do the trick.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •