, Cor
- Original Message -
From: Hank [EMAIL PROTECTED]
To: C.R. Vegelin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, October 05, 2005 5:57 PM
Subject: Re: How to avoid redundancy between PK and indices ?
It depends.. if this is your create table statement:
CREATE
It depends.. if this is your create table statement:
CREATE TABLE foo (
a smallint NOT NULL,
b smallint NOT NULL,
c smallint NOT NULL,
d smallint NOT NULL,
e smallint NOT NULL,
f smallint NOT NULL,
PRIMARY KEY (a,b,c,d,e,f)
);
Then only one unique index is being created on the
@lists.mysql.com
Sent: Wednesday, October 05, 2005 5:57 PM
Subject: Re: How to avoid redundancy between PK and indices ?
It depends.. if this is your create table statement:
CREATE TABLE foo (
a smallint NOT NULL,
b smallint NOT NULL,
c smallint NOT NULL,
d smallint NOT NULL,
e smallint NOT NULL
Hi List,
Is anyone familiar with optimizing indices, including primary key ?
I do have a large myisam table with 6 non-unique key fields, lets say named A,
B, C, D, E and F.
Each of these columns may have NOT NULL values from 0 to 999, and are defined
as SmallInt.
Requirement: each row must
C.R. Vegelin [EMAIL PROTECTED] wrote on 04/10/2005 12:52:01:
Hi List,
Is anyone familiar with optimizing indices, including primary key ?
I do have a large myisam table with 6 non-unique key fields, lets
say named A, B, C, D, E and F.
Each of these columns may have NOT NULL values from 0
: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: How to avoid redundancy between PK and indices ?
C.R. Vegelin [EMAIL PROTECTED] wrote on 04/10/2005 12:52:01:
Hi List,
Is anyone familiar with optimizing indices, including primary key ?
I do have a large myisam table with 6 non-unique key
insert would have to include a full table scan.
Alec
C.R. Vegelin [EMAIL PROTECTED]
04/10/2005 15:10
To
mysql@lists.mysql.com
cc
Subject
Re: How to avoid redundancy between PK and indices ?
Hi Alec,
Thanks for your comment. Well, we disagree on a few points.
Suppose I have