Re: What is Select count(*) from ... doing?
From: Mark Grand <mdg_at_netcom17.netcom.com>
Date: 1995/07/30
Message-ID: <MDG.95Jul30093248_at_netcom17.netcom.com>#1/1
Date: 1995/07/30
Message-ID: <MDG.95Jul30093248_at_netcom17.netcom.com>#1/1
If the select was occurring in the context of a transaction, it would have had to lock and then unlock all of the rows. That would account for twice as many writes as reads.
-- ============================== Mark GrandReceived on Sun Jul 30 1995 - 00:00:00 CEST