Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Record row count and execution time into table?
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 DBAReceived on Sun Oct 02 2005 - 15:43:30 CDT
![]() |
![]() |