Assuming that table 'data' is completely constructed, does index creation order have any performance ramifications?
For example, would it be reasonable to assume that the order of these two statements has no performance impact? (all fields are integer in this case) create unique index data_index_1 on path_data(id, path, date) create index data_index on data(path, date) ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
