Re: Why does NOT IT take so long
From: Karl Penney <aa651_at_ccn.cs.dal.ca>
Date: 1995/07/25
Message-ID: <DC90F3.KJA_at_cs.dal.ca>#1/1
Date: 1995/07/25
Message-ID: <DC90F3.KJA_at_cs.dal.ca>#1/1
Tom Conder (tconder_at_csc.com) wrote:
I don't think that any NOT expressions in the where clause allow the
use of an index. This may be why is takes longer than you think it
: When writing Oracle SQL, why does the NOT IN statement take so long?
-- Karl Penney |~~~~~~| _/^\_ |~~~~~~| DMR Group, Halifax, NS | | _/\_\ /_/\_ | | aa651_at_cfn.cs.dal.ca | | >___________< | | 74203.673_at_compuserve.com |______| | |______|Received on Tue Jul 25 1995 - 00:00:00 CEST