On 25 Oct 2006 at 11:54, Meena wrote:

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

Sorry, but I can't believe. Show us both queries and their plans.
And, BTW, the situation you describe can affect query speed, but you
said that query results were different...

--
SY, Dimitry Sibiryakov.