RE: Using the Index (Tables)....

2004-08-05 Thread Peter Vertes
or access while the command is running. -Pete -Original Message- From: Scott Fletcher [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 11:01 To: [EMAIL PROTECTED] Subject: Using the Index (Tables) I have one question. Once I create 2 or more indexes to a table, should I in

FW: Using the Index (Tables)....

2004-08-05 Thread Scott Fletcher
-Original Message- From: Scott Fletcher Sent: Thursday, August 05, 2004 11:00 AM To: 'KSTrainee' Subject: RE: Using the Index (Tables) One more question. Does the column's name have to be in order by col1, col2 and col3? Or does it not matter which order, like c

Using the Index (Tables)....

2004-08-05 Thread Scott Fletcher
I have one question. Once I create 2 or more indexes to a table, should I instruct MySQL to use which index in certain order? (Like use that 2nd index, not the 1st one). Another question, do I need to run the maintance on the index? If so, how? With IBM DB2, I had to run the index maintance we