How Many Columns Can Be Used To Create A Composite Index?

1.	How Many Columns Can Be Used To Create A Composite Index?
Answer» A composite index can SUPPORT 32 columns as LONG as total size of the columns does not exceed DB_BLOCK_SIZE. A composite index can support 32 columns as long as total size of the columns does not exceed DB_BLOCK_SIZE.

Answer»

A composite index can SUPPORT 32 columns as LONG as total size of the columns does not exceed DB_BLOCK_SIZE.

A composite index can support 32 columns as long as total size of the columns does not exceed DB_BLOCK_SIZE.

Discussion