Re: Code for Query Plan(s) Generation

From: <quanunique_at_my-deja.com>
Date: 2000/02/17
Message-ID: <88i0sn$tli$1_at_nnrp1.deja.com>#1/1


In article <88h1kb$5ii$1_at_nnrp1.deja.com>,   msharaf_at_main-scc.cairo.eun.eg wrote:
> Hi all
>
> Currently doing my research, I need a module that generates for a
> given query all its alternative plans(not the optimal one only) in the
> form of operator tree (DAG), by applying the several algebraic
> transformations, without any cost estimations.
>
> I wonder if you can tell me where i can find such a library or
> framework, as i do need it seriously & urgently.
>
> Thanks a lot in advance, Mohamed
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

check out OPT++ of Univ. of Wisconssin (http://www.cs.wisc.edu) or Lambda-DB at http://lambda.uta.edu)
OPT++ has source code, you may be able to use it to generate all the plans. I am not sure about Lmbda-DB's optimizer. By default, it gives you the optimal.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 17 2000 - 00:00:00 CET

Original text of this message