On Mon, Sep 26, 2011 at 12:06 PM, firebirdsql <firebirdsql@...> wrote:

> I have the following view:
> CREATE VIEW as example
> AS
> SELECT col1 FROM table1 INNER JOIN table2 USING(col1);
>

> Then when I use it:
> SELECT a.col1, a.col2, a.col3 FROM table1 AS a INNER JOIN example
> USING (col1);
>
>
> Is the optimizer smart enough to figure out that it can join table1
> directly to table 2 and get col1, col2, col3? Or does it process the view
> first and then join it to table1 (redundant) and get col1, col2, col3?
>

In this case yes, but some views must be instantiated first, so the general
case is more complicated.

> Is it possible to display a detailed execution plan?
>

With isql, you can say set plan, or set plan only.

Good luck,

Ann

>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]