Even for inserts, index key values cannot span
multiple blocks. An attempt to create an index where
a single key value won't fit in a single block will
result in an ORA-1450 "maximum key length exceeded".
-- Anita
--- "Hillman, Alex" <[EMAIL PROTECTED]>
wrote:
> Update in the index is done as d
Update in the index is done as delete and insert, so there is no chaining.
Alex Hillman
-Original Message-
Sent: Thursday, July 05, 2001 5:46 PM
To: Multiple recipients of list ORACLE-L
I've been asked to create an index which combines two fields, date &
location.
For reasons I don't r
Charlie Mengler wrote:
>
> I've been asked to create an index which combines two fields, date & location.
> For reasons I don't really want to explain, we need/desire this index to
> be in the order of date, location. The minor gotcha is that while location
> will be populated at the time the rec
I've been asked to create an index which combines two fields, date & location.
For reasons I don't really want to explain, we need/desire this index to
be in the order of date, location. The minor gotcha is that while location
will be populated at the time the record is created, the date field is