Received: from bjke.com (firewall-user@[144.210.8.38]) by hub.org (8.8.8/8.7.5) with ESMTP id QAA00728 for ; Wed, 22 Jul 1998 16:50:35 -0400 (EDT) Received: by bjke.com; id PAA15988; Wed, 22 Jul 1998 15:50:34 -0500 (CDT) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (4.1) id xmab14843; Wed, 22 Jul 98 15:49:28 -0500 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id <3XAFWQD1>; Wed, 22 Jul 1998 15:51:33 -0500 Message-ID: From: "Jackson, DeJuan" To: Herouth Maoz , Federico Passaro Cc: pgsql-sql@postgreSQL.org Subject: RE: [SQL] Re: Autoincrement Date: Wed, 22 Jul 1998 15:51:30 -0500 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain > At 11:06 +0300 on 20/7/98, Federico Passaro wrote: > > > > When I have to pay this penalty: on insert / update / query ? > > Query, I think. > I would think you would have to pay this penalty for all accesses to that column. Meaning in any WHERE|ORDER BY|GROUP BY clause that the column is accessed. Which could be for INSERT, UPDATE, and SELECT, DELETE. INSERT because if indexes UPDATE because of WHERE, if not indexed SELECT because of WHERE/ORDER BY/GROUP BY DELETE because of WHERE, if not indexed -DEJ