RE: Is it possible to use nolock type of hint in query

>>> The example I heard in a presentation about SQL Server isolation
levels was an airline seat reservation system: you wouldn't consider as available a seat that had been reserved by another session, whether committed or not. Dubious, probably just a way to cast SQL Server's inferior read consistency model in a positive light, but there it is.

...har har...reminds me of the weak documented reasons Informix bothered with Dirty Read (ANSI Read Uncommitted):

      ANSI Read Uncommitted or Informix Dirty Read is the most efficient isolation level.

      The reading program never waits and never makes another program wait. It is the

      preferred level in any of the following cases:

1. All tables are static--concurrent programs only read and never modify data.
2. The table is held with an exclusive lock.
3. Only one program is using the table.

So, it is the most efficient...
We hear that one on occasion about features introduced from 8i forward...

--
http://www.freelists.org/webpage/oracle-l