Hi,
I want an urgent help in tuning this query.
select "a","b","c" frm vw_arc where ( nbr in ( 1,2,3,4,5,.......,2000) or nbr in (2001,.....,4000)
or nbr in(4001,....60001) or nbr in(5000,.......7000) or nbr in(7001,.......9001))
order by d,e ;
Here the columns selected are almost 100 in number
and the nbrs are not sequentials and almost 500 in each set and the numbers in each set is exclusive to the other set,
so this query is very log and it is taking a lot hell of time.
Any tuning tip on this ???
vw_arc is a view on the main table.