Re: Slow response of forms

From: mRangel <marcus.rangel_at_gmail.com>
Date: 31 Aug 2006 12:57:45 -0700
Message-ID: <1157054265.048300.137750@i42g2000cwa.googlegroups.com>

Raj wrote:

About this one below, can you create an index on PFPL_ZUG.PZUG_ID, refresh your statistics for those tables and try again ?

[]´s
Rangel

> SELECT A.FPL_ID,A.PZUG_ID,A.PZV_KEY,A.EINBRUCHZEIT,A.STRECKE_ID,
> A.BST_REIHENFOLGE,COUNT(*),B.ZN
> FROM
> PZV_BSTKETTE A,PFPL_ZUG B WHERE (A.PZUG_ID = B.PZUG_ID ) GROUP BY
> A.FPL_ID,
> A.PZUG_ID,A.PZV_KEY,A.EINBRUCHZEIT,A.STRECKE_ID,A.BST_REIHENFOLGE,B.ZN
> HAVING COUNT(*) > 1
>
> Rows Row Source Operation
> ------- ---------------------------------------------------
> 0 FILTER
> 44625 SORT GROUP BY
> 44624 NESTED LOOPS
> 3665 TABLE ACCESS FULL PFPL_ZUG
> 44624 TABLE ACCESS BY INDEX ROWID PZV_BSTKETTE
> 48288 INDEX RANGE SCAN (object id 6452)
>
> ********************************************************************************
Received on Thu Aug 31 2006 - 14:57:45 CDT