Re: Need help on query performance issue

Thanks for notifying it. Please find attached my explain plan and the SQL script. Please help.

Reg,
An

On Thu, Oct 1, 2009 at 3:04 PM, Balakrishna Y <krishna000_at_gmail.com> wrote:

> Hi,
>
> There is no evidence for your question at all .... just post you query and
> statistics of your table & indexes ...
>
> Only then some one can help you out in this .
>
> Regards
>
> Bala
>
>
> On 10/1/09, Shastry(DBA) <shastry17_at_gmail.com> wrote:
>>
>> Hi Gurus,
>> I have Oracle query which runs fine in production and test1 server but
>> taking more time in the recently cloned two more dev servers. i checked for
>> explain plan and got that two tables are having FULL TABLE SCANS and didnt
>> find anything FTS issue in production and test1 servers with the same data.
>> I did analyze two databases completely to have latest stats collection but
>> didnt help :(.
>> How to tackle this issue please guide.
>> Thanks in advance.
>>
>> Reg,
>> An
>>
>
>

--
http://www.freelists.org/webpage/oracle-l




text/plain attachment: Explain_Plan.txt



application/octet-stream attachment: test.sql