Re: KEEP Pool and full-table scans?

Despite all this, it is seldom a good idea (performance wise)

to plan frequent short table scans. Index or hash based access

is invariably much more efficient.

But how vcan you prevent the CBO from doing a full tbale scan agsinst a table that is only on a few data blocks?

--
Posted via http://dbforums.com