Matt Clark [EMAIL PROTECTED] writes:
I've noticed that the cost estimates for a lot of my queries are
consistently far to high.
You seem to be under a misapprehension. The cost estimates are not
in units of milliseconds, they are on an arbitrary scale with 1.0
defined as one disk fetch.
LIMIT
Hi,
I've noticed that
the cost estimates for a lot of my queries are consistently far to high.
Sometimes it's because the row estimates are wrong, like
this:
explain analyze
select logtime from loginlog where
uid='Ymogen::YM_User::3e2c0869c2fdd26d8a74d218d5a6ff585d490560' and result =
PROTECTED]
Subject: Re: [ADMIN] Cost estimates consistently too high - does it
matter?
Matt Clark [EMAIL PROTECTED] writes:
I've noticed that the cost estimates for a lot of my queries are
consistently far to high.
You seem to be under a misapprehension. The cost estimates