Unless its using bitmap indexes and then its possible.
--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"ianal Vista" <ianal_vista_at_hotmail.com> wrote in message
news:Xns976EA5E64A891ianalvistahotmailcom_at_70.169.32.36...
> Galen Boyer <galen_boyer_at_yahoo.com> wrote in news:u8xs8dtyv.fsf_at_rcn.com:
>
>> On Sat, 18 Feb 2006, tonyrogerson_at_sqlserverfaq.com wrote:
>>> And another one....
>>>
>>
>> Yes, it isn't an easy task, but one which can be done by solid
>> programming practices.
>>
>>> , particularly if an ad hoc query tool is used.
>>
>> Well, that isn't an application, so, sure, deadlocks can happen.
>
> In Oracle readers do NOT block writers & writers do NOT block readers.
> Any ad hoc query tool will NEVER cause a dead lock in Oracle!
Received on Sun Feb 19 2006 - 01:37:15 CST
