Are indexes always created for foreign key constraints? I just noticed in the information_schema.indexes table that I apparently have a number of duplicate indexes because I didn't realize indexes were being created automatically when I added a foreign key constraint.
I gather this behavior isn't uniform for all sql dbs: google tells me sql server doesn't do this. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.