AllExperts > Experts 
Search      

Oracle

Volunteer
Answers to thousands of questions
 Home · More Questions · Answer Library  · Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Suchitra Joshi
Expertise
I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader and some basic dba activities or performance tuning for Oracle 8i database. I cannot answer questions related to major dba activities, backup and recovery.

Experience
10+ years
D2K

Awards and Honors
OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, Database, PL/SQL

 
   

You are here:  Experts > Computing/Technology > Oracle > Oracle > Index

Topic: Oracle


Expert: Suchitra Joshi
Date: 7/3/2008
Subject: Index

Question
1>How to check a query is utilizing a particular index.


2>If a table consists of 2 or 3 indexes then how to guide the query to make use of a particular index.
Suppose I have A and B indexes on my table so how to guide my query to utilize the index A?
              OR
How to check which index is being used by my query?


Answer
Hi Binay,

1) You can check the query execution using EXPLAIN PLAN. More info at following site -
  http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96533/ex_plan.htm

2) You can change the query execution plan by specifying HINTS. More info at following site -
http://www.psoug.org/reference/hints.html

Hope this helps

Regards

Suchitra

Add to this Answer    Ask a Question



  Rate this Answer
   Was this answer helpful?
Not at allDefinitely              
   12345  

     
About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright  © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.