Re: Incredible slow down... Why?
Posted by:
Lucio Menci
Date: September 09, 2014 01:58AM
> I'm disagreeing with that suggestion. Instead, slow queries are bets handled by finding and fixing the root cause.
> [...]
> OPTIMIZE TABLE removes some or all of the wasted space in a table. This is like "defragmenting".
I think the Optimize tables updates the statistics too. Maybe the indexes hasn't the statistics updated, because I made this and the select into my customer PC was as fast as my pc.
> to have a script (in shell, Perl, etc) that performs the function
Can you tell me how make this script?
Thank you!
Subject
Views
Written By
Posted
1608
September 05, 2014 05:25AM
807
September 05, 2014 02:43PM
811
September 07, 2014 10:43AM
882
September 08, 2014 07:37AM
988
September 08, 2014 09:56AM
Re: Incredible slow down... Why?
850
September 09, 2014 01:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.