Re: TKPROF output
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Wed, 30 Mar 2011 14:56:42 -0500 (CDT)
Message-ID: <5551f82f46f511f3f200dafdd3af525b.squirrel_at_society.servebeer.com>
Jamey writes:
Date: Wed, 30 Mar 2011 14:56:42 -0500 (CDT)
Message-ID: <5551f82f46f511f3f200dafdd3af525b.squirrel_at_society.servebeer.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 30 2011 - 14:56:42 CDT