Sure, if you are a database expert, it might be disappointing but I enjoyed reading it.
I've been tripped up by the where in partial indexes before. Same goes for expression indexes.
Hope this explanation helped explain why, at least a little bit.
Sure, if you are a database expert, it might be disappointing but I enjoyed reading it.