Re: TKPROF output
- From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 30 Mar 2011 14:56:42 -0500 (CDT)
Jamey writes:
> Probably just need an index on you weight_uom column (note Full Table
> Scan).
The elapsed time of the fetch is 0.9s, so reducing that by way of an index
can only reduce the total elapsed time by something less than that, which
probably won't be noticeable/valuable from 30s.
Also, judging from past experience, units of measure (reasonable assumption
of the WEIGHT_UOM values) are generally low cardinality, which the optimizer
may choose to bypass anyway, depending on Oracle version and the bind
variable value.
My $.02,
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
