Re: Why does NOT IT take so long

From: Rob Verlander <robv_at_accessone.com>
Date: 1995/07/24
Message-ID: <3v0ieg$mnb_at_pulm1.accessone.com>#1/1

tconder_at_csc.com (Tom Conder) wrote:
>When writing Oracle SQL, why does the NOT IN statement take so long?

A NOT IN clause will always result in a full table scan and any indexes that you may have will be IGNORED.

Rob Verlander
robv_at_accessone.com Received on Mon Jul 24 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Mike Morgan: "Re: Modifying SQL*Plus Command Prompt on UNIX"
In reply to: Tom Conder: "Why does NOT IT take so long"
In reply to Roger Snowden: "Re: Why does NOT IT take so long"
Next in thread: Mike Morgan: "Re: Modifying SQL*Plus Command Prompt on UNIX"
Reply: C.J. Jardine: "Re: Why does NOT IT take so long"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message