Get started Bring yourself up to speed with our introductory content.

The Oracle Guru Answer #9

Did you guess correctly? Check your answer to this week's quiz.

Were you correct? This week's answer is:
c. 32

An Oracle index, which is the structure that supports the primary key constraint, can have a maximum of 32 columns, according to SearchOracle.com expert Brian Peasland.

For More Information

Expert response: Composite primary keys and indexes

Expert response: Sort order of composite primary keys

Expert response: New or composite primary key for a composite table?

Expert response: Performance of primary/foreign keys in parent and child tables

Expert response: Maximun number of columns for a composite primary key

Do you have an idea for a quiz question topic? Let us know!


Dig Deeper on Oracle DBA jobs, training and certification

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close