Re: CBO calculates lower cost, but runs slower...

In a sudden spasm of awareness,
Connor McDonald doodled thusly:

>
>Given your circumstances, you could always try FIRST_ROWS for the entire
>database. I know that this is taking a hammer solution (to a problem
>that is not necessarily a nail!) but FIRST_ROWS often keeps the users
>happier at the cost of overall database performance. They see the first
>screen of their Discoverer (or whatever) result set earlier and think
>that life's grand...
>

Yeah, but if he ever does an export or import, he'd better turn it back off or be prepared to hint the expvews...

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Tue Nov 20 2001 - 03:40:46 CST