RE: Doubt related to ROWID
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: Ric Van Dyke <ric.van.dyke@xxxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Jul 2013 15:09:18 +0000
Ric,
I know, I was just trying to out-geek you.
Regards
Jonathan Lewis
________________________________________
From: Ric Van Dyke [ric.van.dyke@xxxxxxxxxx]
Sent: 24 July 2013 16:07
To: Jonathan Lewis; ORACLE-L
Subject: RE: Doubt related to ROWID
Roger that, what I was more joking at was to not even get the row at
all. The fastest way to do anything is to not do it at all. ;-)
(My kids seem to have listen to me a bit too much on this point....)
===================
Ric Van Dyke
Education Director
Hotsos Enterprises LTD.
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan@xxxxxxxxxxxxxxxxxx]
Sent: Wednesday, July 24, 2013 11:04 AM
To: Ric Van Dyke; ORACLE-L
Subject: Re: Doubt related to ROWID
Well,
You could avoid the LIO by using the result cache, but there are far
fewer latches on the result cache, so not doing the LIO might cause more
contention and therefore be more resource-intensive than doing the LIO
;)--
//www.freelists.org/webpage/oracle-l
Other related posts:
