RaghavendraK 70574
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]

Reply via email to