Re: Inconsistent Query Results
From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Sat, 28 Jun 2003 15:58:09 +0000
Message-ID: <3054222.1056815889_at_dbforums.com>
Date: Sat, 28 Jun 2003 15:58:09 +0000
Message-ID: <3054222.1056815889_at_dbforums.com>
ABOUT NULLS
to: sybrandb
"When an indexed column is NULL, or when all columns in a concatenated index are NULL, then the row concerned will NOT have an entry in the index"
Quote from:
Oracle SQL High-Performance Tuning
Second Edition
Page 120, paragraph 8 "NULL VALUES"
Author:Guy Harrison
(c) 2001 - Prentice Hall PTR
-- Posted via http://dbforums.comReceived on Sat Jun 28 2003 - 17:58:09 CEST