Re: Database Tuning Issue or Redesign ??

On Fri, 06 Jun 2003 00:34:05 GMT, "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote:

>Sorry, can you run it through tkprof so we can see the more human readable
>output.
>Jim
>
>--

Jim, there is nothing wrong with the query. He would either better run a 10046 trace or following my suggestion and check whether a single record fits in 1 physical block. My guess is it doesn't, so row chaining will explain his performance problem.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 05 2003 - 23:13:12 CDT