Multiple-Column Indexes Question

2006-08-03 Thread Arias Gonzalez, Javier
Assuming we have the following table: CREATE TABLE test ( id INT NOT NULL, last_name CHAR(30) NOT NULL, first_name CHAR(30) NOT NULL, PRIMARY KEY (id), ); With last_name having 1,000 different values and first_name having 1000,000 different values... What is

Re: Multiple-Column Indexes Question

2006-08-03 Thread Chris
Arias Gonzalez, Javier wrote: Assuming we have the following table: CREATE TABLE test ( id INT NOT NULL, last_name CHAR(30) NOT NULL, first_name CHAR(30) NOT NULL, PRIMARY KEY (id), ); With last_name having 1,000 different values and first_name having