Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Record row count and execution time into table?

Re: Record row count and execution time into table?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 02 Oct 2005 22:43:30 +0200
Message-ID: <0hh0k11kqnfk735jln5urjp7c6qarkkeme@4ax.com>


On Sun, 02 Oct 2005 16:46:45 GMT, "IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote:

>Since NULLs are not stored in an index, the results might not be 100%
>accurate if the index is used to generate the COUNT.

Tables have Primary Keys, don't they?
Even the worst table design with all columns null allowed has at least a surrogate PK.
Applies to almost all commercially sold US 'database agnostic' shitware.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sun Oct 02 2005 - 15:43:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US