I am currently in the early stages of writing an outline for a new book on indexing, targeted towards novice DBAs. While this topic has been done to death in hundreds of articles, presentations, and books, I think there is still room for a book that makes the topic easy to read and easy to understand for beginners. The focus on the book would be on the essential (not esoteric) indexing skills that DBAs need to perform their job on a day-to-day basis.
I would really appreciate your advice and feedback on what such a book should include. For example:
- What part(s) of indexing do you find very easy to understand?
- What part(s) of indexing do you find the most difficult to understand?
- What topics do you think I should include in the book that would be of the most help to you?
- What topics do you think I should not include in the book because they are not helpful for the typical DBA?
- Can you provide me URL’s of articles on indexing that you think are particularly good, or particularly bad?
- What’s the best book you have ever read on indexing? What’s the worst book? And why?
If you have any feedback on any of the above topics (you don’t have to answer all of the above question), please post them below. The more feedback I get, the better I will be able to write a book that will best fit the needs for novice DBAs. Once the book is done, it would become freely available as an eBook, just as all my recent books have been.