danch wrote: Even ignoring the table-lock escalation issue, this is what should happen. In fact, I'm a little surprised that Oracle doesn't just create the indices: I believe PostgreSQL does.
I believe it's because they want to allow a DBA to configure the index in a specific way e.g. in a specific tablespace, with additional columns for index-only joins, as part of the PK (leading to CMR problems :-( ), and so on. I don't think MS-SQL creates an index either (although it's self-tuning mechanism may add one later). ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development