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
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
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 were
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
