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
To: firebird-support@yahoogroups.com
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]