Thanks for this explanation, it was helpful! Question - I have a simple SELECT * query similar to yours but when I add index_ffs and parallel_index hints the plan shows that both are unused, and it simply uses an INDEX RANGE SCAN instead (no parallism). Any idea why that would be? For context, the table is huge (6 billion rows), and the WHERE condition filters out all except ~100 million rows.
Always scratching my head on this situation, glad to have it finally explained so nicely ;)
So which one was the fastest? Love the KIWI acronym
@6:08 so true!
Thanks for this explanation, it was helpful! Question - I have a simple SELECT * query similar to yours but when I add index_ffs and parallel_index hints the plan shows that both are unused, and it simply uses an INDEX RANGE SCAN instead (no parallism). Any idea why that would be? For context, the table is huge (6 billion rows), and the WHERE condition filters out all except ~100 million rows.
Figured it out. Its because index_ffs only works when no ROW access is required - but in my case the SELECT * requires row access. TY
Great explanation ! Thank you )
You are welcome!
Neat explanation 👌🏻
Thank you 🙂
Nice