On Tue, Dec 18, 2007 at 02:10:02PM -0600, John Stanton wrote:
> 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 say it precisely: although it won't be ignored - but (in the case
mentioned above) it won't be used anyway, and won't spoil the speed gain,
given by index, right?
I'm asking, because tries with new database I prefer to make without
indexing, and add indexes later. So I was wondering, should I then check the
code again, to remove some "ORDER BY"-s, or can I skip it.
--
pozdrawiam / regards
Zbigniew Baniewski
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
