Re: Help - Simple SQL query doing full table scans

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: 7 Jan 2002 23:55:26 -0800
Message-ID: <bde5777e.0201072355.401c48c0@posting.google.com>

Hello Sunil,

it might be the case that the columns CLIENT, SSN, H_COVTP have been declared as optional (nullable). If so, the index cannot be used as starting point.

Kind Regards,

Herman de Boer Received on Tue Jan 08 2002 - 01:55:26 CST

This message: [ Message body ]
Next message: Tarjei T. Jensen: "Re: Opinions: Upgrade from Oracle 7.3.4 to Oracle 9?"
Previous message: Klaus Naumann: "Creating Standby DB From Backup"
In reply to: Sunil Bakshi: "Help - Simple SQL query doing full table scans"
Next in thread: Howard J. Rogers: "Re: Help - Simple SQL query doing full table scans"

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

Original text of this message

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