They're harder to completely understand than they are to read; it often happens for example that SQLite won't use existing indexes, for no obvious reason.