| indexing [message #41385] |
Thu, 26 December 2002 09:19  |
Ravi
Messages: 251
Registered: June 1998
|
Senior Member |
|
|
Hi,
I have a table which has a unique PK index on a column
, but my sql is running very slow, how to make the sql to use that unique index, i mean is there a way to provide a hint to the sql.
In my sql iam joining this table which has 6 columns with a parent table which has around 70 columns.
Appreciate any help
Thanks
Ravi
|
|
|
|
| Re: indexing [message #41386 is a reply to message #41385] |
Thu, 26 December 2002 10:32  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
first
look into the execution plan.
if the indexes are not made use of,
then, you can force oracle to make use of indexes.
You can use HINTS to do this.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
