oracle determine index used for query via sqlplus

Posted on 2011-04-19
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 73

    Accepted Solution

    "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)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now