PROTECTED]
cc:
Subject:Re: Oracle 8.1.7 can only use the first 15th indexes?
Amen to that. I had a table with about 40 indexes on v7.0.16. I don't
think that it was possible that any of them could have been ignored,
because all of them were used. I can't verify that, because this system
Notes in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearance2:
March 2004 Hotsos Symposium - Keynote
March 2004 Charlotte NC -
Amen to that. I had a table with about 40 indexes on v7.0.16. I don't
think that it was possible that any of them could have been ignored,
because all of them were used. I can't verify that, because this system was
born and died (subsequently cremated) over 10 years ago and I never thought
to
drop table t1;
create table t1
nologging
pctfree 50
pctused 50
as select
1 n01,
1 n02,
1 n03,
1 n04,
1 n05,
1 n06,
1 n07,
1 n08,
1 n09,
1 n10,
1 n11,
1 n12,
1 n13,
1 n14,
1 n15,
rownum n16,
lpad(rownum,10) v1
from all_objects
;
create index i01 on t1(n01);
create index i02 on
Let's be realistic: any table with 15 indexes
PROBABLY needs a little bit of a re-design
exercise? ;)
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
snip
(I assume the report intended to say the first 15
indexes on a specific table, 'cos the data dictionary
alone has
The first 15 indexes CREATED?
Joking, are they?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
I've just been reading a report for one of our systems and it says that Oracle 8.1.7
will only use the first 15
indexes created. Any index created after the 15th will be ignored
Data warehouse with bitmap indexes ?
But in OLTP I would assume guilty until
proven innocent.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next
this mean that I'm reading another myth? Couldn't confirm it on metalink.
Ta,
Leng.
---
From: Jonathan Lewis [EMAIL PROTECTED]
Date: Wed, 21 Jan 2004 07:20:30 -
Subject: Re: Oracle 8.1.7 can only use the first 15th indexes?
drop table t1;
create table t1
nologging
pctfree 50
Hello again,
I've just been reading a report for one of our systems and it says that Oracle 8.1.7
will only use the first 15 indexes created. Any index created after the 15th will be
ignored unless specified via a hint. Is this correct? I haven't heard of this before.
TIA,
Leng.
