Thank you for you response. I was looking for a query rewriting mechanism
which would be outside the optimizer and will do this kind of
transformations at the query level.
~Mahendra
On Fri, Jul 24, 2009 at 7:32 PM, Kevin Grittner wrote:
> mahendra chavan wrote:
> > What I meant by de-correla
mahendra chavan wrote:
> What I meant by de-correlation was optimizing a query to get rid of
> sub-queirs by using joins.
>
> eg. In the TPC-H schema, a query to find out the names of suppliers
> who supply parts having size < 100
>
> *Query with nested subqueries:*
>
> SELECT
> S_NAME
>
I am sorry for not elaborating on that. What I meant by de-correlation was
optimizing a query to get rid of sub-queirs by using joins.
eg. In the TPC-H schema, a query to find out the names of suppliers who
supply parts having size < 100
*Query with nested subqueries:*
SELECT
S_NAME
FROM
mahendra chavan wrote:
> I am a master's student in computer science at IIT Bombay. As part of my
> project, I need to get a decorrelated version of a SQL query. Please could
> anyone let me know if we have query decorrelation feature implemented in
> postgres ?
What do you mean by "query deco
