you can name indexes as you wish. if you use select - you should specify coluns names. engine well decide what index to use depend on CREATE INDEX statement and you SQL query.
On Saturday 02 May 2009 02:45:03 a a wrote: > 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
