DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: index and data conversion

Threaded View

  1. #1
    Join Date
    Jun 2000
    Posts
    295

    index and data conversion

    Hi,

    Table test(col1 varchar2(32) not null,
    col2 number not null,
    other_columns,,,)
    index i_test on test(col1, col2)
    Query select ... from test
    where col1 = 'this is test'
    and col2 = '12345';

    I do not remember exactly whether I saw an article from
    AskTom.com, saying this data conversion (col2) may cause
    i_test index not being used.
    When I used autotrace trace only, I find the index
    is used.

    Even changing index on test(col2), the index
    is still used.

    Can someone ********?

    Thank you!
    Last edited by sysdba; 02-20-2003 at 03:23 PM.

Posting Permissions

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


Click Here to Expand Forum to Full Width