Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1N2fCx52195 for ; Thu, 22 Feb 2001 21:41:12 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from smtprelay1.adelphia.net (smtprelay1.adelphia.net [64.8.25.6]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1ILELx65319 for ; Sun, 18 Feb 2001 16:15:15 -0500 (EST) (envelope-from kquinlan@computer.org) Received: from kquinlan ([24.51.172.121]) by smtprelay1.adelphia.net (Netscape Messaging Server 4.15) with ESMTP id G8Z1M400.CKO for ; Sun, 18 Feb 2001 16:13:16 -0500 From: "Kevin Quinlan" To: Subject: Estimation of SQL statements Date: Sun, 18 Feb 2001 16:11:52 -0500 Message-ID: <000801c099ef$6ace91d0$79ac3318@kquinlan> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Disposition-Notification-To: "Kevin Quinlan" X-Archive-Number: 200102/345 X-Sequence-Number: 1541 Are there any good techniques that estimate the time it will take to execute an SQL statement, specifically an INSERT, SELECT, UPDATE, or DELETE? What factors are important to consider when estimating the execution time of these types of SQL statements? Thank you, Kevin