Storing data in a database seems like a simple task. The tables are created and your data is added/edited/deleted as required. But beyond this is the need to make sure your tables are properly indexed to make sure that commonly accessed tables/fields are responsive to queries. Creating indices borders on an art or even black magic in some cases and it is up to the DBA to chose the correct indices to create.

But why can current databases not decide on which indices are the best for your particular solution? We do have the turning wizard in SQL Server 2005 but surely this should be an automatic task that the database can perform. Coding Horror continues the dicussion on this interesting topic.