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.

Artur

----- Original Message -----
From: "Stevio" <redeagle@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, June 11, 2002 1:01 PM
Subject: Re: [ib-support] Big slow select query from multiple tables


> > >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?
>
> Thanks.