P
Patrick Tingen
Guest
It also depends on the distribution of the data. And nr of records. If you have a table with - say - a few hundred records, why bother at all; just define a unique index and leave it at that. That is, if it is not accessed too much. On the other hand: if this is a really **huge** table, with lots and lots of write operations, you want less indexes, whereas if it is **huge** and has lots and lots of read operations, you probably want more. Without knowing how the data is composed or used, it is nearly impossible to give a good advice.
Continue reading...
Continue reading...