| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: performance impact of index
On Fri, 21 May 2004 14:04:05 -0400, "Gordon" <gordon_t_wu_at_hotmail.com>
wrote:
>Even when the Optmizer choose NOT to use these indexes, it is still no
>slower than full table scan, right?
Due to the fact a full table scan uses multiblock reads and an index scan doesn't, an index scan may be slower than a full table scan.
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri May 21 2004 - 15:06:16 CDT
 |
 |