Gurus, I am going to have a big table with lot of records, to expedite searching i wanted to index on a key field (which is numeric value). BUT, there will be records which will have same value for the key field (other columns will be different).
so how can i do this? right now, i am getting error, about duplicate entries and they are being discarded. All entries are important and I have to find a way to locate records based on this key field. thx for help. Rajeev -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql