Re: consistent read and LIO question

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 20 Apr 2009 18:16:10 +0200
Message-ID: <753lf7F168ir7U1_at_mid.individual.net>

On 19.04.2009 09:02, srivenu.kadiyala_at_gmail.com wrote:
> The index could be a non-unique index.

The index *is* non unique which you can conclude from the range scan mentioned in the first posting.

> The leaf block could have been pinned a second time to check that
> there are no other index values (id = 1000).
> You could try creating a unique index and run the test again

Cheers

        robert Received on Mon Apr 20 2009 - 11:16:10 CDT