OraFAQ Forum: Performance Tuning » Index not being used in Query

Home » RDBMS Server » Performance Tuning » Index not being used in Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Index not being used in Query [message #161569]

Mon, 06 March 2006 01:39

samidc
Messages: 35
Registered: February 2006

Member

I have a query in which in where condition i have condition only on transaction id and books id as

select * from table_name
where trans_id = 'trans_id'
and booksid = 'bks_id';

there is an unique index on trans_id and no where any function is used in where clause of the query.
Still full tabel scan is happening. index is not getting used.

Can somebody let me know the reason and how to make index used?
Note :Index hints are not allowed.

Thanks

Report message to a moderator