I want to know how can i use HINT in query to use index of my choice
if u can give me an example of it that will be great
I am using (Oracle8i workgroup addition)
Thanks in Advance
from India
Printable View
I want to know how can i use HINT in query to use index of my choice
if u can give me an example of it that will be great
I am using (Oracle8i workgroup addition)
Thanks in Advance
from India
SELECT /*+ INDEX E,IDX1 */
FROM Employee_T E
WHERE
...
Hser is the link for you:
http://otn.oracle.com/docs/products/.../doc_index.htm
- Chris