I am adding some indexes to an existing database to improve performance. I am 99.9% sure they are unique, but... it was a while ago that I was in that code. Are there any performance reasons to make them unique or make them not unique? From the stand point of risk, my inclination is to make them not unique.
While I am on the topic of indexes. One of the indexes is for a systems lookup table, just has category, name, and value. The size is fixed in development. Currently there are about 25 rows. Is there any advantage to an index or because of the small size, will that only hurt performance? Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
