 |
|
Oracle Tips by Burleson |
Index
Builds
The next phase of the database build was the
application of indexes. The index builds were also scripted and the
times for each index build logged. These times demonstrate update
performance via updates to indexes. Figure 3.4 shows the comparisons
for all index builds between the SSD and SCSI/ATA databases on the
dss_adminschema.
As with the insert testing the updates into the
SSD array required 30% less time than the updates into the SCSI/ATA
arrays. This compares favorably with other researchers results. The
complete index build comparison statistics are shown in Appendix C.
Again, this shows that for update based activity
and complex searching and sorting such is done with indexing, an SSD
array will outperform standard technologies by at least 30%.
In the next phase, another complex task will be
covered, the analyze runs to capture object statistics for the cost
based optimizer.
The above book excerpt is from:
Oracle
Solid State Disk Tuning
High Performance Oracle
tuning with RAM disk
ISBN
0-9744486-5-6
Donald K. Burleson & Mike Ault
http://www.rampant-books.com/book_2005_1_ssd.htm
|
