Zbigniew Baniewski wrote:
One more thing: suppose, I created an index for the column "name". Should I
then take care to avoid ending the clauses with "ORDER BY name" - or just
it doesn't matter, and it'll be automatically ignored?
It won't be ignored. If you have an index ordered in the sequence
specified by the ORDER BY Sqlite will use that order instead of having
to assemble the result set and sort it.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
