Hi, Everybody. It's simple question. But i am in confusion. I have table with huge number of records but only 3 columns (suppose col1, col2, col3). col1 is primary key and I have created the Index on the column (i.e. col2) which is not a primary key. Problem 1) is that will it make any difference in performance while searching the record on col2 with above scenario. 2) other problem is that is it necessary to recreate the index on col2 whenever new records are added to table. is it true that mysql will recreate the index for that column by itself with a new records added or deleted.
With Best Regards. From: Smitesh S. Damdoo