Re: query tuning

From: hrishy <hrishys_at_yahoo.co.uk>
Date: 4 Nov 2003 03:00:00 -0800
Message-ID: <4ef2a838.0311040300.1a622589_at_posting.google.com>

Hi All

After some research i solved this problem..now the query takes about 30 seconds ..it ws slwo initially as the literals were not able to make use of the histogram and they were missing.After caculatiung histograms for the missing column the query takes about 30 seconds.Jasper thank you for your help.

regards
Hrishy Received on Tue Nov 04 2003 - 12:00:00 CET

This message: [ Message body ]
Next message: Rob Ward: "Re: problem with dbca on Oracle 9i R2 9.2.0.1.0 Linux"
Previous message: Julia Sats: "ODP.Net vs OO4O"
Maybe in reply to: hrishy: "query tuning"
Next in thread: Ed prochak: "Re: Choosing DBMS and architecture for ecommerce website"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message