Subject | Execute statement |
---|---|
Author | Mahesh Ishwar |
Post date | 2003-11-19T04:37:53Z |
Hello All,
Does queries executed within execute statement(that is as string), uses indices defined on them?
I've a query which if not executed via execute statement, uses index defined on a column, but if executed within execute statement, doesn't shows me the index defined on a coulmn in the plan .
Thanx in Advance.
Mahesh.
---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
[Non-text portions of this message have been removed]
Does queries executed within execute statement(that is as string), uses indices defined on them?
I've a query which if not executed via execute statement, uses index defined on a column, but if executed within execute statement, doesn't shows me the index defined on a coulmn in the plan .
Thanx in Advance.
Mahesh.
---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
[Non-text portions of this message have been removed]