list, based on the recommendation of posters (Jack) ,
i re-created the index with all the columns of a table ! (all 8 of them)
analyzed the table/index and now all the queries are satisfied off an
indexed
range scan..
i also put the indexes on raw devices.
regards
> --
> From:
Rahul,
If I'd known that there were only 8 columns in the table, I'd have included
the recommendation to investigate an Index-Organized Table. That is where
the table IS the index and the index IS the table. This saves disc space
and cuts I/O in half for DML on the table, since a separate index
Title: RE: waits on sequential scans - how did i solve it
Is this table/index now suitable to be a IOT, it will certainly save some space on an 18M row table
John
-Original Message-
From: Rahul [mailto:[EMAIL PROTECTED]]
Sent: 24 July 01 14:53
To: Multiple recipients of list
I don't think, 7.3.2 supports Index-Organized tables.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 24, 2001 10:36 AM
> Rahul,
>
> If I'd known that there we
I was going to say the same thing until I saw what version of Oracle
he was running. Its a Oracle8 and up feature so Rahul is SOL.
-Original Message-
Sent: Tuesday, July 24, 2001 7:36 AM
To: Multiple recipients of list ORACLE-L
Rahul,
If I'd known that there were only 8 columns in the
Igor,
How right you are! I answered without looking back at Rahul's original
message.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Mess
Jack,
I was going to suggest, what you did, but then I noticed the version Rahul
was using.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 24, 2001 5:58 PM
>