<[email protected]> wrote in message news:[email protected] > It was frustrating and confusing becuase I have not encountered this > index-name feature in any other DB I've worked with
What feature? You are not saying that no other DB you worked with allowed you to create indexes, are you? What precisely, in your opinion, is so different about how SQLite handles indexes? I don't understand your problem at all. > and its > undocumented on sqlite.org. it doesnt give any restrictions or > recommendations for index names What recommendations did you expect? You can name an index anything you want. An index name is only ever used in CREATE INDEX and DROP INDEX statements, so the exact name is largely irrelevant. > it doesnt even say when you must use > them or not use them Nothing forces you to use inexes. You may want to create some to improve performance of certain queries, but you don't have to. > so one could simply guess Guess at what? Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
