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 -> optimizer_max_permutations

optimizer_max_permutations

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 24 Nov 1999 20:53:02 +0800
Message-ID: <383BDFAE.7789@yahoo.com>


This shows the upper limit for the optimizer, but is there any way of determining whether any SQL's are actually approaching this limit. As a more general question, is there any way of determining on an SQL by SQL basis, the number of permutations that the optimizer actually came up with ?

--



Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."
Received on Wed Nov 24 1999 - 06:53:02 CST

Original text of this message

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