Do index names need to be different from field names? When doing selects on indexed fields, can I use the field name, or must I use the index name?
I just want normal indexes, i'm not looking to create indexes for multiple fields. Can I say: CREATE INDEX x ON t (x); ? or does it have to be: CREATE INDEX index_t_x ON t (x); ? assuming the latter, can I say SELECT * FROM t ORDER BY x; or do I have to say ORDER BY index_t_x; to receive the speed benefit of the index. I tried CREATE INDEX x ON t (x); in SQLite3.exe, and no error was reported, but I don't want to assume anything. This is extremely ambiguous and confusing. I've got enough field names, I don't want to have to start dealing with unique index names as well in SELECT/INSERT/UPDATE queries. Thanks for the help. Feeling very frustrated atm. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
