Re: Anyone know any WP which explains about FTS vs Index Scan?

Tune for time or you’re wasting time. Which one is more time intensive when processing for the specific SQL in question? This shouldn’t be an all or none.

On Tue, Apr 10, 2018 at 10:40 AM Andy Sayer <andysayer_at_gmail.com> wrote:

> Flip the problem on its head. Where does it say in the docs that full
> table scans must be reduced?
>
> Obviously, full table scans are powerful and are the best way of getting
> lots of data quickly if your filters are highly selective (return many
> rows).
>
> Using an index is plain stupid if the filter is highly selective, it is
> crazy to want to visit many blocks one by one, using a fresh buffer in the
> cache as you go.
>
> If your dinasaur doesn’t agree that something that is faster and uses less
> latches is better then maybe they’re really an osterich?
>
> Or maybe they’re working to achieve a different set of metrics?
>
> Regards,
> Andrew
>

-- 


[image: Kellyn Pot'Vin on about.me]

*Kellyn Pot'Vin-Gorman*
DBAKevlar Blog <http://dbakevlar.com>
President Rocky Mtn. Oracle User Group <http://www.rmoug.org/>
President Denver SQL Server User Group <http://denversql.org/>
about.me/dbakevlar

--
http://www.freelists.org/webpage/oracle-l