(Hemant K Chitale) We generally use the PARALLEL keyword to speed up index creation thus : CREATE INDEX ….. PARALLEL n. But also results in the Parallel attribute being set for the index, which means that Oracle may choose to read the index using Parallel Query operators.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help