Need help on query performance issue

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.


Other related posts: