See below: --- Jacob Engstrand <[EMAIL PROTECTED]> wrote: >.... To disable the > I1A index, > rewrite the WHERE clause like this: > > SELECT * FROM t1 WHERE a+0=5 AND b='xyzzy'; > > To disable the I1B index you could write > > SELECT * FROM t1 WHERE a=5 AND b LIKE 'xyzzy'; >
Why not add a feature to SQLite to allow the user to choose the index to use? Maybe something like this: SELECT * FROM t1 WHERE a=5 abd b='xyzzy' USE INDEX(a) Wouldn't this be much more straiht forward and easier to read? __ Raymond Irving --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
