Re: value from index block or table block

From: Grzegorz Goryszewski <>
Date: Wed, 23 Nov 2011 19:45:10 +0100
Message-ID: <>

On 2011-11-23 19:10, Jonathan Lewis wrote:
> It's difficult to say for certain (and may be version dependent), but it's
> probably getting columns from the index whenever possible.
> Two arguments in favour:

Thanks, that might explain strange behavior of our obj$ dictionary table, because we are unable to drop one user table . The reason is (I think) when index access is used table name is 'corrupted' (different name) than that in obj$ data block :). So we are getting object does not exists but when You force full scan on obj$ , displayed name is proper .
Received on Wed Nov 23 2011 - 12:45:10 CST

Original text of this message