Hi
I am reposting from Clarion Newsgroups - as there is now a renewed interest
amongst Clarioneers in Firebird.
We have the obvious choices of ASA, MSSQL/MSDE, MySQL, FireBird and
Clarion's own file driver TOPSPEED.
I am hoping that the Firebird experts here can clear up any
problems/misundertandings we newbies from the Clarion world may have.
Cheers
JVZ
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: 02 April 2004 09:27
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird cannot optimize a query when


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
>
>
>
>

----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---
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]