Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    87

    Unanswered: Composite Indexes

    How do I find if there are any composite indexes existing?
    INDEX_TYPE shows NORMAL for composite as well , right?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    By composite you mean consisting of more than one column? If so:

    select index_name
    from user_ind_columns
    group by index_name
    having count(*) > 1;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •