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.