RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:
One another thing is how does reversing of value and column work, i mean the internals of it. Does it create any temp table ...
No, it just scans all records one by one, and runs the test for each record.
And i see the sqlite documentation of like, which say if the first char is not a wild char then index will be helpful.
Only if you have (columnName LIKE 'pattern') test, and a few other conditions are met (in particular, the index must use COLLATE NOCASE clause since LIKE is case-insensitive by default). An index cannot be used for ('string' LIKE columnName) test.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------