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

Pages

Sunday, 5 February 2017

Query to Check to see what Columns are Indexed on Table

The relevant query is as follows:

SELECT column_name, index_name
FROM     all_ind_columns
WHERE  table_name = ‘<TABLE_NAME>’;

U = unique index
N = non-unique index
Share this article :

2 comments:

  1. Salve


    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 Columns are Indexed on Table!

    I'd like to be able to log all constraint errors when users are running an application having Oracle as the back-end. That means inserting a record into an Errors Log table in Oracle.

    Is that even possible? In an exception clause, I could do that; however, when a constraint fails, I don't know where I'd be able to run such code to do the insert.

    Is this even possible?

    Thanks for any help you can give.

    Wayne

    Appreciate your effort for making such useful blogs and helping the community.


    ,Merci

    ReplyDelete
  2. Hello Dayakar,

    I learnt so much in such little time about Query to Check to see what Columns are Indexed on Table . Even a toddler could become smart reading of your amazing articles.
    I have requirement like

    select COL1,Col2 from A
    minus
    Select COL1,COL2 from B;

    both tables have 50+ millions record so I want to automate a job which will execute this query for 1millions records for one time and then again 1 millions for second time...like loop and store output in record type.

    But nice Article Mate! Great Information! Keep up the good work!

    Kind Regards,
    Preethi.

    ReplyDelete