|Subject||Re: [firebird-support] Indexes in Firebird|
The difference is that when i give the order by clause of a field from the master table, the output comes ordered by that specific field and the index of the transaction table is not considered at all.If I remove the order by clause of the master table field, the index of the transaction field is effective.
----- Original Message -----
From: Dimitry Sibiryakov
Sent: Friday, October 20, 2006 3:04 PM
Subject: Re: [firebird-support] Indexes in Firebird
On 20 Oct 2006 at 7:12, Meena_Sethu wrote:
>In MS Access the index of the transaction table is considered first
>and then of the master table, But in Firebird the smallest index is
>considered first and then the index with two or more fields. As a
>result the output in both differ.
What's the difference?
SY, Dimitry Sibiryakov.
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
Yahoo! Groups Links
[Non-text portions of this message have been removed]