Updating index on oracle table lmr women dating
Indexes are logically and physically independent of the data in the associated table.
In general you should consider the following important points, focusing in the fact that there are two kinds of statistics: index and column statistics.
1) By default, the UPDATE STATISTICS statement updates both index and column statistics.
Many shops are replacing their platter-style disks with solid-state disks, and creating a very small data buffer, just for the updates.
The book Oracle Tuning: The Definitive Reference notes that if you are still using traditional disks, many shops segregate high-updates objects (tables & indexes) into a separate blocksize so that they can have a separate, small data buffer."By segregating high activity tables into a separate, smaller data buffer, Oracle has far less RAM frames to scan for dirty block, improving the throughput and also reducing CPU consumption.
First, the database must find a place to store the row.