| rebuilding indexes ..!!! [message #141041] |
Thu, 06 October 2005 13:59  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai,
we have a client with 8i under linux.
they are using the app and is slow today.
the particular part of the app is freezing and the tables involved have lacs of records and also indexed.
Will there be any increase in the performance if we rebuild the indexes ..?
or else how to increase the performance ...?
plz help out.
regards
bala
|
|
|
|
|
|
| Re: rebuilding indexes ..!!! [message #141046 is a reply to message #141042] |
Thu, 06 October 2005 14:29  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
we need to clarify ourself.
we have gathered the statistics to trigger the CBO.But immediately after it was done , the application is freezing and so we deleted the statistics and now it is working and not too fast.but when we did the same for a 9i server , it is working good.
why is it so...?
for 8i server itself , the optimizer mode is choose (CBO).
So , gathering stats for the objects in 8i will cause adverse effects in app...?
if so, how to improve performance other than gathering stats..?
|
|
|
|
|
|
| Re: rebuilding indexes ..!!! [message #141065 is a reply to message #141041] |
Thu, 06 October 2005 15:24 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
You really shouldn't be doing all of these changes in production. Get yourself a test copy to work with.
It could be that the app was designed to not have statistics. But we really have no way of knowing, we don't have enough information to help.
Did it all of a sudden start freezing? What was changed right before the freeze first happened? Undo that.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
