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

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / I can't recall every having an index on the primary key
Post #212,139
by jbrabeck
6/22/05 4:12:27 PM
6/22/05 4:16:09 PM
Reply
New I can't recall every having an index on the primary key
unless this qualifies:
Client - Primary key client number
Orders - Primary key client number/Order number
- Index Client number/Order number in reverse order (for online listings showing most recent orders first)
A good friend will come and bail you out of jail ... but, a true friend will be sitting next to you saying, "Damn...that was fun!"
Collapse Edited by jbrabeck June 22, 2005, 04:16:09 PM EDT
I can't recall every having an index on the primary key
A good friend will come and bail you out of jail ... but, a true friend will be sitting next to you saying, "Damn...that was fun!"
Collapse All History
     Indexes and primary keys - redundant? - (tablizer) - (9) - June 22, 2005, 04:43:16 PM EDT
         I can't recall every having an index on the primary key - (jbrabeck) - June 22, 2005, 04:16:09 PM EDT
         As I understand it - (tuberculosis) - (1) - June 22, 2005, 06:57:51 PM EDT
             It's definitely the case with Oracle. -NT - (Meerkat) - June 25, 2005, 09:30:22 AM EDT
         The Primary Key is an Index. - (ChrisR) - June 22, 2005, 07:26:24 PM EDT
         Conceptually no, in practice yes - (JayMehaffey) - (3) - June 22, 2005, 10:40:41 PM EDT
             Relational theory does not address indexes - (tablizer) - (2) - June 22, 2005, 11:10:09 PM EDT
                 Indexes are just tables.... - (ChrisR) - (1) - June 22, 2005, 11:24:01 PM EDT
                     Re: just tables. - (mmoffitt) - June 23, 2005, 10:36:27 AM EDT
         Check the index list. - (static) - June 23, 2005, 01:11:11 AM EDT

The feeling is there, but you have a long way to go to CRC's level.
107 ms