Hi,

>> At which point (layer) do you expand the list (represented as string) into the new evaluation
>> items
>> ((ID BETWEEN 5 and 10) or (ID BETWEEN 20 and 30) or (ID = 50))?
>>
> In the optimizer.

It doesn't belong there IMO.

>> If i correctly understand this wouldn't be able to use an index on ID.
>>
> It could be handled for index walk as BETWEEN X AND Y, with X being the
> lesser and Y being the higher value of the list.

Then it should be before the optimizer, but what when a parameter is used?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info



--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
1010 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!