Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle join table index question: what is the “right” way to create index?
Hi:
I have a question to create index on FKs in a join table.
As an example, say we have three tables:
UserTable:
User_ID (PK) User_FirstName User_LastName
AccountTable:
Account_ID (PK)
Account_Name
...
UserAccountTable:
User_ID (PK)(FK)
Account_ID (PK)(FK)
…
Are User_ID and Account_ID in UserAccountTable automatically indexed because of the composite PK in Oracle? Or only the leading column (User_ID in this case) is indexed?
Now say I want to index all FKs in the database. Which of the following is correct in terms of UserAccountTable?
My understanding is I should do #2. I looked at a couple of books and couldn’t find the answer. Where can I find the “official” answer?
If you reply, please send a copy to zlmei_at_hotmail.com
Thanks in advance.
Guang
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jan 20 2000 - 15:50:55 CST