Re: speeding up a select to work with dirty data

From: Eugenio <eugenio.spadafora_nospam_at_compaq.com>
Date: 2000/07/12
Message-ID: <8khbtn$qt3$1@mailint03.im.hou.compaq.com>#1/1

select in oracle is no locking.
There is no parameter that you must set
like in Sybase or MS SQL.

I don't know the way to read dirty data in oracle. I guess it is not possible.

--
be happy

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
orauser_at_my-deja.com wrote in message <8kgc5u$eu2$1_at_nnrp1.deja.com>...


>What is the way to speed up a select to return without

>exclusive locking?  I dont want to block out other people

>and I dont care if the data is dirty..

>

>Thanks!

>

>

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Wed Jul 12 2000 - 00:00:00 CDT