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 delete
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
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 record
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
