Re: Index on Primary Key

Thanks for the feeback, Mike.

>Note it doesn't have too, but could use a table scan.
>This is obviously only efficient for tables with a small number of rows. As
>indexes for small tables are also a small overhead the default action is to
>always create them. Thank goodness.

Again, Mike, why an AK that is identical to the PK?

Why can't the db use the PK? Received on Fri Apr 23 1999 - 09:54:39 CDT