Re: Why the index is not used?

From: Evan Ehrenhalt <eehrenh_at_emory.edu>
Date: Thu, 11 Apr 2002 12:43:11 -0400
Message-ID: <3CB5BD1F.88529D3F@emory.edu>

The columns you are looking at are NULL able. How does the data look?

Evan

Saikat Chakraborty wrote:
>
> Dear all,
> Oracle version 8.1.7.0
> OS Windows NT 4.0
> I have a table of structure
> CREATE TABLE AC_ROAMING_POSTED_0423 (
> SERIALNO NUMBER (20),
> RECTYPE VARCHAR2 (2) NOT NULL,
> PLMNID VARCHAR2 (5) NOT NULL,
> IMSI VARCHAR2 (15) NOT NULL,
> RCI_ACCOUNTNO VARCHAR2 (10),
> SVCNO VARCHAR2 (20),
> CHRGDTTIME DATE NOT NULL,
> ---- Nore fields
> )

[SNIP] Received on Thu Apr 11 2002 - 11:43:11 CDT