Re: optimizer_max_permutations

Checj parse times of sql statements, the longer it parses the more plans it could be checking .....

Anjo Kolk

Connor McDonald wrote:

> 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 Thu Nov 25 1999 - 03:48:17 CST