Johan,

What are these emails about?

Besides, indices are for faster lookups, not for ordering.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

> 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
>
> Let me know.
>
> Regards,
> Jack T.
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.647 / Virus Database: 414 - Release Date: 2004-03-29
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>