performance issue with sql query in UAT, But good in local [message #629268] |
Fri, 05 December 2014 03:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/4df9e773eacc91ad29b10af5ad04664d?s=64&d=mm&r=g) |
raja.i
Messages: 11 Registered: November 2014
|
Junior Member |
|
|
Actually single table shows {local db(4483 rows),UAT Database(6284 rows)} an issue by degrading performance,
as it is not be applied with index properly in UAT database, but working good in Local database. i just checked with indexes, hints, stastics.
but still it doesn't show any improvement in my UAT environment. As i'm in developer level, what are the parameters,
i have to check in DB to match atleast good performance in UAT like local DB. Please give some useful suggestion.
Thanks.
|
|
|
|
|