| Orale Hints? [message #65806] |
Thu, 30 December 2004 07:03  |
pavan
Messages: 10
Registered: October 2001
|
Junior Member |
|
|
if i have 2 tables like Employee and Department.
i have Emp_pk1,Emp_pk2,Emp_pk3,Emp_pk4 indexes on Employee table
and
Dept_pk1,Dept_pk2,Dept_pk3 indexes on Department table.
How to put forcebly indexes on both Employee and Department tables using oracle hints?
For a single table we can put like this
"select /* INDEX_ASC(Employee Emp_pk2) */
For two tables how i can forcibly put indexes?
suppose i want to forcibly put index on
Emp_pk2 on Employee table and Dept_pk3 on Department table?
How i can ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
