Hi,

> FROM: NewsServer - discuss.softvelocity.com NewsGroup comp.lang.clarion
>
> I'd like to commend you for such clearly laid out queries.
>
> Provided you've done your homework in the backend with indexes, it's
> appears to me that Firebird cannot optimize a query when the ORDER BY

spans

> tables. This is a common weakness of most RDBMSs. ORDER BYs that span
> tables are also very common when tables are linked with artificial
> information. Most people prefer to use artificial information, as do I.
>
> I don't think the prognosis is good, but here is something that you could
> try:
> Setup UNIQUE indices:
> VPCLI.MatchCode ASC, VPCLI.NumLoc ASC
> VPVIL.NumInt ASC, VPVIL.NumCli ASC

I can't find the head from this thread?
Are you posting to the wrong list?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
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 Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81