explanation: what i've found is cost has absolutely no bearing on
anything, a relatively useless number.
joe
Baylis, John wrote:
> I have a table of 500,000 records that is analyzed and contains
> several indexes that are analyzed.
>
> Can someone explain to me why the cost without a hint i
Title: cost based optimizer
John:
The
Cost of a query is based on Oracle's estimation of the number of datablocks that
will have to be read in order to resolve the query. The Index-access Plan's cost
is higher because Oracle is estimating that it will have to process more
datablocks to ret
First, you should be aware that the Cost is only Oracle's best guess as to
what Access Path is faster. It's often wrong.
What version are you on? Depending on version you have several options
1. Create a histogram on the XSKSHDRS181M1 column
2. Set the optimizer_index_cost_adj equal to a valu
