IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New As I understand it
Declaring a primary key results in the automatic creation of a unique constraint on the primary key. To enforce the constraint, the dbms uses an index.

So its implied already.

Foreign keys, OTOH, do not automatically get indexed but can often benefit by the addition of a non-unique index - depending on access patterns.

If I am wrong, somebody please correct my understanding.



"Whenever you find you are on the side of the majority, it is time to pause and reflect"   --Mark Twain

"The significant problems we face cannot be solved at the same level of thinking we were at when we created them."   --Albert Einstein

"This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses."   --George W. Bush
New It's definitely the case with Oracle.
Two out of three people wonder where the other one is.
     Indexes and primary keys - redundant? - (tablizer) - (9)
         I can't recall every having an index on the primary key - (jbrabeck)
         As I understand it - (tuberculosis) - (1)
             It's definitely the case with Oracle. -NT - (Meerkat)
         The Primary Key is an Index. - (ChrisR)
         Conceptually no, in practice yes - (JayMehaffey) - (3)
             Relational theory does not address indexes - (tablizer) - (2)
                 Indexes are just tables.... - (ChrisR) - (1)
                     Re: just tables. - (mmoffitt)
         Check the index list. - (static)

But if you call right now, you might get an appointment by then.
82 ms