On Friday 23 Aug 2002 11:46 am, Tourtounis Sotiris wrote:
> Hello i have a question baout the functionality of index.
>
> select Y.att0 from class X, class Y where ((X.att0 = %d) and (X.att1 <=
> Y.att0) and (Y.att0 <= X.att0))
Run EXPLAIN ANALYSE SELECT .... and if the output doesn't make any sense post
it back here, then we'll be able to see.
See Ch11 of the user's guide for an explanation of EXPLAIN.
- Richard Huxton