Re: [PHP] OT - database and indexes... but anyone please?

On 2005-09-26, Rory McKinley <[EMAIL PROTECTED]> wrote: > If the index in question happens to be a unique index or a primary key > (really just a special case of index) I thought a primary key is something defined at the logical, where an index is defined at the implementation level.. Therefore,

RE: [PHP] OT - database and indexes... but anyone please?

Gustav Wiberg on Saturday, September 24, 2005 9:48 PM said: > Thanx! Ok so I had to look up and down that message 3 or 4 times before I found this insignificant one line response. TRIM YOUR POSTS! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, vi

Re: [PHP] OT - database and indexes... but anyone please?

Rory Browne wrote: >>If the index in question happens to be a unique index or a primary key >>(really just a special case of index) - you could be breaking the logic >>of the table (allowing duplicates where there should be none). > > > Couldn't that only happen if you dropped a UNIQUE or PRIMAR

Re: [PHP] OT - database and indexes... but anyone please?

Rory Browne wrote: deleting an index(a good index that > is) would slow the db down in certain cases. Deleting a "bad index" > would speed certain operations up. If the index in question happens to be a unique index or a primary key (really just a special case of index) - you could be breaking t

Re: [PHP] OT - database and indexes... but anyone please?

- Original Message - From: "Rory Browne" <[EMAIL PROTECTED]> To: "Gustav Wiberg" <[EMAIL PROTECTED]> Cc: "PHP General" Sent: Sunday, September 25, 2005 1:26 AM Subject: Re: [PHP] OT - database and indexes... but anyone please? I'm not

Re: [PHP] OT - database and indexes... but anyone please?

I'm not an expert on databases, and I haven't a notion of mailing you off-list, with information that could potentially benifit others as well, but from my understanding, deleting an index(a good index that is) would slow the db down in certain cases. Deleting a "bad index" would speed certain oper