Re: Need help on query performance issue
- From: Balakrishna Y <krishna000@xxxxxxxxx>
- To: shastry17@xxxxxxxxx
- Date: Thu, 1 Oct 2009 15:04:43 +0530
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@xxxxxxxxx> 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
>
Other related posts:
