Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: GLOBAL TEMPORARY table - serious join performance problem

Re: GLOBAL TEMPORARY table - serious join performance problem

From: Brian Dick <bdick_at_cox.net>
Date: Thu, 23 Sep 2004 10:35:29 -0400
Message-ID: <11dbclzlpu4ps.dh82t1bdvn49$.dlg@40tude.net> 





On Thu, 23 Sep 2004 00:50:44 +0000 (UTC), Jonathan Lewis wrote:



> Read about dynamic sampling.

> 

> Use a level where all tables without

> statistics are sampled at run time, and

> your problem will go away.




Cool feature. The docs don't say anything about its use with GTT. Are there
any special considerations when using dynamic sampling with GTT's? Does the
sampling get performed only for the segments bound to the
session/transaction or do all GTT segments get sampled?
Received on Thu Sep 23 2004 - 09:35:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US