Index for not equal condition
398600May 17 2007 — edited May 17 2007Hi,
I would like to know how can we force oracle to use index for conditions other than = conditions.
As in one of my query ,
SELECT Char_name
FROM upload_control
where job='AAA'
and num<'1001'
and cycle=1
order by Char_name desc
Is it possible by using optimizer hint ...and whether it will really improve the performance.
Regards,
Sandeep Saxena