Hi all
I have a table with ca. 4Mio Rows.
here is my simple select-statement:
SELECT * FROM CUSTOMER WHERE CUSTOMER_ID=5
the result appears after about 27 sec.
what's wrong?
the same statement on mysql takes 1 milisec.
please help
here is the structur of the table
CREATE TABLE
Am Mi, den 10.11.2004 schrieb Steinar H. Gunderson um 11:17:
On Wed, Nov 10, 2004 at 10:35:50AM +0100, Cao Duy wrote:
here is my simple select-statement:
SELECT * FROM CUSTOMER WHERE CUSTOMER_ID=5
It seems like you're missing an index on customer_id. Set it to PRIMARY KEY
or do