At 02:50 PM 6/11/2002 +0100, Artur Anjos wrote:

>From: "Stevio" <redeagle@...>
>
> > > >How does NATURAL work, or what does it do?
> > >
> > > Natural just means the server scans the entire table
> > > in "natural" order and does not use an index to lookup
> > > the table contents.
> > >
> > Is this a bad thing or a good thing?

At 02:50 PM 6/11/2002 +0100, Artur Anjos wrote:

>Bad thing. Natural picks all your data and evaluate it to your conditions.
>If you have an index FB could use it to make things faster.

Assuming you have some conditions and that they are suitable
to index...

Regards,

Ann
www.ibphoenix.com
We have answers.