I can't recall every having an index on the primary key

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #212,139

by jbrabeck

6/22/05 4:12:27 PM

6/22/05 4:16:09 PM

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!"

Edited by jbrabeck June 22, 2005, 04:16:09 PM EDT

Expand 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

iwethey.org

The thing about the explosive diarrhea excuse is you can really only use it once.
40 ms