Thank you. Alexander A. Gnatyna wrote: > 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 >
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
