Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

Query to Check to see what Indexes are on Table

The relevant query is as follows:

SELECT index_name
FROM    all_indexes
WHERE table_name = ‘<TABLE_NAME>’;

Share this article :

2 comments:

  1. Hello There,


    Query to Check to see what Indexes are on Table being contrived to exist for many projects simply so it can be run will be the first to hit the wall, but those projects where the functions to make existing transactions cheaper in real world applications will find the elusive real world demand.

    1) This is my question that needs to be answered.
    option or create a simple materialized view.

    It was cool to see your article pop up in my Google search for the process yesterday. Great Guide.
    Keep up the good work!

    Thank you,
    Bindu

    ReplyDelete
  2. Hello There,

    Seems like I won the lottery here….This is a treasure box of blogs and your folks are like leprechauns! Phenomenal read on Query to Check to see what Indexes are on Table !

    I am getting ORA00909 when i try to run my query with the following CASE WHEN statement:

    CASE WHEN AV4.ALLOC_GRP_NO IN (SELECT ALLOC_GRP_NO FROM QRMTIPS.QCTRL_ALLOC_GRP_PROFILE WHERE
    DISP_CD = 'WHDV' GROUP BY ALLOC_GRP_NO
    HAVING COUNT(DISTINCT(MTR_SPLIT_NO)) > 1) THEN SUM(AV4.GAS_VOL,0) ELSE
    NVL(av4.gas_vol, 0) END AS ALLOC_MM_GAS

    Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.

    Thank you,
    Preethi.

    ReplyDelete