Best "how to index" docs/books

From: kyle Hailey <kylelf_at_gmail.com>
Date: Mon, 13 Jan 2020 12:30:51 -0800
Message-ID: <CADsdiQhvpzgqfjYiXPo96X57TAxO60oMy+o_9W1kDnHfRKeXVQ_at_mail.gmail.com>



What are the best docs or books out there on methodologies for Index? The first past approach is just to look at execution plan, see where there are full tablescans scanning significant # of rows or blocks with predicate or join filters that filters out most of the rows. Then extending that index opportunity to other SQL and seeing which columns might be included in the index and what order. I like this description from a PostgreSQL extension
https://rjuju.github.io/postgresql/2020/01/06/pg_qualstats-2-global-index-advisor.html .

Many years ago, Mogens Nørgaard recommend Dan Tow's book "SQL Tuning" to me for SQL tuning methodologies and to this day it has been the best example of a prescriptive , step by step process, to find the best (or near best) execution plan for a SQL statement, and ended up helping me lead a project to implement it in software
<http://dboptimizer.com/2011/07/08/woohoo-vst-takes-the-next-step/>.

Would like to find something similar for indexing to find optimal opportunities for adding indexes.

Feel free to say what not to read. Knowing what not to read can be important as well.

Thanks
Kyle

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 13 2020 - 21:30:51 CET

Original text of this message