Re: [PERFORM] getting estimated cost to agree with actual

2008-06-02 Thread Scott Marlowe
On Mon, Jun 2, 2008 at 7:20 PM, Gregory Stark <[EMAIL PROTECTED]> wrote: > "Scott Marlowe" <[EMAIL PROTECTED]> writes: > >> On Mon, Jun 2, 2008 at 3:43 PM, Justin <[EMAIL PROTECTED]> wrote: >>> >>> I have noticed that estimated Cost to do the query is way off from Actual. >> >> Well, they're not m

Re: [PERFORM] getting estimated cost to agree with actual

2008-06-02 Thread Gregory Stark
"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On Mon, Jun 2, 2008 at 3:43 PM, Justin <[EMAIL PROTECTED]> wrote: >> >> I have noticed that estimated Cost to do the query is way off from Actual. > > Well, they're not measured in the same units. estimated costs are in > terms of the cost to sequent

Re: [PERFORM] getting estimated cost to agree with actual

2008-06-02 Thread Scott Marlowe
On Mon, Jun 2, 2008 at 3:43 PM, Justin <[EMAIL PROTECTED]> wrote: > As i've been looking over the more complicated queries that i have written > and gotten allot of help in redoing the quires from you all, thanks again. > > I have noticed that estimated Cost to do the query is way off from Actual.