Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


oracle determine index used for query via sqlplus

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-05-11
I need to figure out which index is being used when i run a particular query.  I only have sqlplus access to the database and tables, and I doubt that I have access to any system views, though I do have DBO on my db and tables.

Question by:techport13
1 Comment
LVL 74

Accepted Solution

sdstuber earned 2000 total points
ID: 35426532
"DBO"  ?  That's a sqlserver term.

however, you should be able to do this...

explain plan for                 -- leave this line alone
select * from your_table;   -- change this line to be your query

when that completes, run this...

select * from table(dbms_xplan.display)


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension . This reminded me of questions that come up here at EE along the lines of, "How can I tell the type of file from its cont…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month10 days, 7 hours left to enroll

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question