Re: Performance ploblems using "order by"

Try this hint:

select /*+ USE_CONCAT INDEX(employees idx_name_age) */ from employees
where age > 0; /* forces the optimizer to use index idx_name_age */ Received on Tue Feb 16 1999 - 12:00:54 CST