Indexing Question.
From: Tyler Van Gorder <tvangod_at_ecst.csuchico.edu>
Date: 4 Feb 1995 22:17:48 GMT
Message-ID: <3h0uec$lb_at_charnel.ecst.CSUChico.EDU>
Date: 4 Feb 1995 22:17:48 GMT
Message-ID: <3h0uec$lb_at_charnel.ecst.CSUChico.EDU>
Hi, I had a question about indexes in Oracle:
If you have a 4 part primary key do you need to define an index on each column or can you define an index on the entire key. If the second is the case, how is performance when say 2 of the 4 columns are supplied in a query?
Our table will contain 1,000,000 + records, and we are trying to determine the best way build indexes on that table.
Thx.
Tyler Van Gorder
Systems Programmer
Landa Management Systems.
Received on Sat Feb 04 1995 - 23:17:48 CET