Question about Cost in Oracle Explain Plan
Posted
by Will
on Stack Overflow
See other posts from Stack Overflow
or by Will
Published on 2010-04-05T16:22:13Z
Indexed on
2010/04/05
16:23 UTC
Read the original article
Hit count: 311
When Oracle is estimating the 'Cost' for certain queries, does it actually look at the amount of data (rows) in a table?
For example:
If I'm doing a full table scan of employees for name='Bob', does it estimate the cost by counting the amount of existing rows, or is it always a set cost?
© Stack Overflow or respective owner
