FAQ      Foxhound Home      RisingRoad      Breck.Carter@gmail.com


Question: The table ... has no primary key, unique constraint or unique index.

Answer: Because there is no way to uniquely identify each row in this table, queries and database recovery operations may be slow.

Four different flavors of this message may be produced, flagged as Note, Warning, Caution and Danger:

Note: The table ... has no primary key, unique constraint or unique index.
This table currently has fewer than 1,000 rows so there may be no performance problems, but if the table grows larger those operations may become extremely slow.
Warning: The table ... has no primary key, unique constraint or unique index.
This table currently has more than 1,000 rows; performance may not be a problem now but if the table grows larger those operations may become extremely slow.
Caution: The table ... has no primary key, unique constraint or unique index.
This table has more than 100,000 rows so there is a very real chance those operations will be extremely slow.
Danger: The table ... has no primary key, unique constraint or unique index.
This table has more than one million rows so there is a very real danger those operations will be extremely slow; think geological time scale :)

See also...
The table ... has no primary key or unique constraint, but does have a unique index.


This page was last updated on March 13, 2010.      FAQ      Foxhound Home      RisingRoad      Breck.Carter@gmail.com