Home » RDBMS Server » Performance Tuning » Orale Hints?
Orale Hints? [message #65806] Thu, 30 December 2004 07:03 Go to next message
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 ?
Re: Orale Hints? [message #65811 is a reply to message #65806] Thu, 30 December 2004 23:14 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Try the following:

SELECT /*+ INDEX(Employee Emp_pk2) INDEX(Department Dept_pk3) */ ...


Best regards.

Frank
Previous Topic: 10g Advisor
Next Topic: Column Level Locking?
Goto Forum:
  


Current Time: Thu Mar 28 18:09:12 CDT 2024