Tài liệu Sybex OCA Oracle 10g Administration I Study Guide phần 9

Using this screen, you can control how the index is rebuilt. For example, you can select the
rebuild method, either offline or online, that is best suited for your environment. Offline rebuilds
are faster but impact application users who need to access the index. Online rebuilds have minimal
impact on users but take longer to complete. You can also specify a “scratch” tablespace where
Oracle stores the intermediate results during the rebuild process. Redirecting this activity to
another tablespace helps minimize potential space issues in the index’s tablespace during the
rebuild. You can also specify whether to gather new optimizer statistics when the index build is
complete. Click Next on this screen to generate an impact report, as shown in Figure 9.59.