Re: Any way to get RowCount by not using Select count(*) from table

On Mon, 04 Jan 1999 14:08:17 -0800, Dan Morgan <dmorgan_at_exesolutions.com> wrote:

>> If your table has a primary key (what table doesn't? :) )
>
>I know this is a segue but as a DBA I would really appreciate it if developers
>would STOP putting primary keys on EVERY table.
>
>For small static tables it takes twice as long for the SQL Engine to read the
>index and then read the table when a single read of the table would suffice.
>This same situation occurs in some cases with larger tables too. And this does
>not exactly enhance performance. If your concern is keeping the table in
>memory make it a cache table.
>
>Daniel A. Morgan

I think I know what you mean, but we should be careful here. The relational model says that every table has a primary key. If for performance reasons you wish to implement a table without an Oracle primary key, you need to know, and document, that this is what you are doing, as well as ensuring that whatever mechanism does update the table contains logic to ensure that the logical primary key is not violated.

Regards,

Eric. Received on Sun Jan 17 1999 - 03:57:48 CST