Hi Gurus,

Greetings. We have a table having 9999 records. My developer is
writing a query to for that table using ROWID Internalrowid . It reported
the no of physical reads is 1389620.
Why it is so?. is there logic on using rowid. if we didn:t use the
rowid then we are getting physical read is less value.. Why it is?.

Is it Necessary to avoid the internalrowid. What is the other method
we can use if we need to avoid the internal rowid.

Thanks
Mudhalvan M.M


Oracle LazyDBA home page