Hi Folks,
I have two queries that are of the form :
select ... from ... where ... in (list1) AND ... in (list2). The two
queries differ only in the size of list2 by 1, but their performances
are quite different. Query2 runs much faster than Query1. The queries
are:
Query 1:
SELECT svm,pmo
Hi Folks,
I have two queries that are of the form :
select ... from ... where ... in (list1) AND ... in (list2). The two
queries differ only in the size of list2 by 1, but their performances
are quite different. Query2 runs much faster than Query1. The queries
are:
Query 1:
SELECT svm,pmo
verbose paliasorigin;
INFO: analyzing "unison.paliasorigin"
INFO: "paliasorigin": scanned 30 of 692947 pages,
containing
16409041 live rows and 0 dead rows; 30 rows in sample,
37901986
estimated total rows
ANALYZE
On Mon, 2008-09-08 at 09:16 -0700, Matt Smiley wrote:
> Hi Kiran,
>
> You gave great info on your problem.
>
> First, is this the query you're actually trying to speed up, or is it a
> simplified version? It looks like the optimizer has already chosen the best
> execution plan for the given qu