Whatarethreebenefitsofperformingdatadefinitionlanguage(DDL)statementsagainstapartitionedtablewiththeUPDATEGLOBALINDEXESclause?()
Whatarethreebenefitsofperformingdatadefinitionlanguage(DDL)statementsagainstapartitionedtablewiththeUPDATEGLOBALINDEXESclause?()
A、GlobalindexesarerebuiltautomaticallyattheendoftheDDLoperationtherebyavoidingproblemswiththeUNUSABLEstatus.
B、YoudonothavetosearchforinvalidglobalindexesaftertheDDLcommandcompletesandrebuildthemindividually.
C、GlobalindexesaremaintainedduringtheoperationoftheDDLcommandandthereforecanbeusedbyanyconcurrentquery.
D、Globalindexesremainintactandavailableforusebydatamanipulationlanguage(DML)statementsevenforsessionsthathavenotenabledtheskippingofunusableindexes.