From derby-user-return-1454-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Jun 22 10:02:54 2005 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 32520 invoked from network); 22 Jun 2005 10:02:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 22 Jun 2005 10:02:54 -0000 Received: (qmail 59203 invoked by uid 500); 22 Jun 2005 10:02:52 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 59178 invoked by uid 500); 22 Jun 2005 10:02:51 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 59164 invoked by uid 99); 22 Jun 2005 10:02:51 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jun 2005 03:02:51 -0700 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=FROM_ENDS_IN_NUMS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [141.76.2.1] (HELO mail.inf.tu-dresden.de) (141.76.2.1) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jun 2005 03:02:52 -0700 Received: from localhost (localhost [127.0.0.1]) by mail.inf.tu-dresden.de (8.12.10/8.12.10) with ESMTP id j5MA2nt3006771 for ; Wed, 22 Jun 2005 12:02:49 +0200 (CEST) Received: from mail.inf.tu-dresden.de ([127.0.0.1]) by localhost (mail.inf.tu-dresden.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05462-06 for ; Wed, 22 Jun 2005 12:02:49 +0200 (CEST) Received: from mail.inf.tu-dresden.de (localhost [127.0.0.1]) by mail.inf.tu-dresden.de (8.12.10/8.12.10) with ESMTP id j5MA2jMK006746 for ; Wed, 22 Jun 2005 12:02:45 +0200 (CEST) Received: from 195.49.158.14 (SquirrelMail authenticated user mt270288) by mail.inf.tu-dresden.de with HTTP; Wed, 22 Jun 2005 12:02:45 +0200 (CEST) Message-ID: <42167.195.49.158.14.1119434565.squirrel@mail.inf.tu-dresden.de> Date: Wed, 22 Jun 2005 12:02:45 +0200 (CEST) Subject: query execution plan From: "Maik Thiele" To: derby-user@db.apache.org User-Agent: SquirrelMail/1.4.4 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-15 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at inf.tu-dresden.de X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hello everybody, is it possible to fetch the query execution plan before the query gets executed? I have some extrem long running queries but SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS() allows me only to look the plan after the query exection. Otherwise if it is not possible at the moment which classes have to be changed to get this feature? Thanks a lot... Maik