I don't have the query to had (it was a while ago) but I had a query
which took about 10 seconds to run. Recreated it as a view and it ran
in 1 second.

--- In firebird-support@yahoogroups.com, German Pablo Gentile
<listas.ggentile@c...> wrote:

> donjules2k wrote:
>
> >Try creating the query as a view, removing the clause
> >
> > TBL_1.ID > 0 and TBL_1.SMALL_FLD1> 0
> >
> >and then select * from the_view where TBL_1.ID > 0 and

TBL_1.SMALL_FLD1> 0

> >
> >I found some of my queries to be far faster after I did this.
> >
> >
> >
> Any query is faster than a View?
> What does a View faster than a query?
>
> TIA
>
> German.