Hi All,
We have a linked server to an Oracle database. The query
performance was very slow, so I recreated the linked
server and set (check the checkbox) the "Index As Access
Path" in the Provider Options to see if the query
performance would improve. Now, when I try to run the
query, it gives me the following error message:
=========== OLE DB provider 'MSDAORA' returned a 'NON-CLUSTERED and
NOT INTEGRATED' index 'PKADDRESS' with incorrect bookmark
ordinal 0.
OLE DB error trace [Non-interface error: OLE/DB provider
returned an invalid bookmark ordinal from the index
rowset.].
===========
Any idea what this mean? I can't find any information on
what that "Index As Access Path" does.
Thanks in advance for any help or suggestions!
--AllanThe Index as Access Path is used for providers that support index seeks.
Most providers do not.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment