Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2015
    Posts
    10

    Question Unanswered: How to Identify Reverse Key Indexes Created in the Database?

    From which Oracle data dictionary column and table can I identify reverse key indexes created in the database? Please advise. Thanks.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Check the INDEX TYPE:
    Code:
    SQL> create table test (col1 number, col2 number);
    
    Table created.
    
    SQL> create index i1 on test (col1);
    
    Index created.
    
    SQL> create index i2 on test (col2) reverse;
    
    Index created.
    
    SQL> select index_name, index_type
      2  from user_indexes
      3  where index_name in ( 'I1', 'I2');
    
    INDEX_NAME                     INDEX_TYPE
    ------------------------------ ---------------------------
    I1                             NORMAL
    I2                             NORMAL/REV
    
    SQL>

  3. #3
    Join Date
    Dec 2015
    Posts
    10
    Thank you so much for the detailed explanation. Appreciate it

  4. #4
    Join Date
    Sep 2016
    Location
    Pune
    Posts
    16
    A solution is make the index a Reverse Key Index.

    CREATE INDEX bowie_reverse_idx ON bowie(id) REVERSE;

    A Reverse Key Index simply takes the index column values and reverses them before inserting into the index.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What "solution"? Did you read the question?

Posting Permissions

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