What about indexes and names? I use MySQL-front for my database. Until now my database has been quite small and I haven't had the need for indexes. Now I want to create some indexes but I'm not quite sure about how it works. Let say that I have two fields out of eight that contain numbers that I search for often. MySQL-front want me to have a name for the index and specify which fields should be in those names. How does i work? Should I create an index for each of these two fields with different indexnames? Should any other fields be in these indexes?
Any help would be appreciated! // Henrik
Any help would be appreciated! // Henrik