On Mon, 20 Jan 2003, Patrick Hatcher wrote:
> I thought I would ask this question here before sending to the Performance
> So I run my Evil query using a condition of gmmid = 6. It takes about 90
> secs to run. However, if I run this and add a LIMIT 100 clause, the query
> runs in less than 5 secs.
Well, some not insignificant portion of that time is being spent making
the complicated select list at the top level. That part would certainly
be sped up if there were less rows to do it for.
Also, does it give the same plan? It is possible that it might choose a
different plan if it only wants 100 rows out.
In response to
sfpug by date
|Next:||From: Josh Berkus||Date: 2003-01-21 16:16:08|
|Subject: Re: Reporting: Oracle-like features?|
|Previous:||From: Patrick Hatcher||Date: 2003-01-20 23:55:19|
|Subject: Re: Patrick's Evil Query|