M
makthar
Guest
Hi Stefan, Please find the responses below. >> This means SQL Performance is poor without running the maintenance commands? In general yes, since SQL evaluates different execution plans for a statement and selects the one with lease cost. So, without statistics, cost of all execution plans might look alike. However, starting from OE 12.0, SQL will be introducing a feature called "Autonomous Update Statistics" (AUS), which updates the statistics without user intervention. >> Shall i run this one time a week (maybe Sunday without users)? In general, statistics should be updated as and when good amount of data changes in tables. If it happened to be the case that, only 5% of total tables has data changes, then only those tables requires new statistics. >> UPDATE TABLE STATISTICS AND INDEX STATISTICS AND ALL COLUMN STATISTICS; Above command updates statistics for all tables, indexes and columns present in the database. Below command allows you to update statistics for specific table. UPDATE TABLE STATISTICS AND INDEX STATISTICS AND ALL COLUMN STATISTICS FOR ; Thanks, Akthar.
Continue reading...
Continue reading...