I apologize for the newbie question, but the answer isn't obvious from looking through the site.
In postgres, I know that if I declare a column or set of columns to have a unique constraint, there is also an index created on those columns. Does the same thing happen in sqlite, or does the optimization engine see the unique constraint as a hint to dynamically create an "automatic" index if existing indices seem insufficient? -sean ----------------------------------------------------------------------------------- This email message is for the sole use of the intended recipient(s) and may contain confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ----------------------------------------------------------------------------------- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
