R
Rob Fitzpatrick
Guest
You can define dozens of indexes per table. But that doesn't mean that you should. Each additional index on a table makes updates more expensive, not to mention maintenance activities like index compact, repair, rebuild, dump and load, etc. Your database design should be guided by the needs of your application(s). If you run up against an architectural limit here then you have probably done something wrong, i.e. your design is very inefficient.
Continue reading...
Continue reading...