3 ms·
Honestly im kind of surprised that they are even that close. I wonder if this changes at scale when the intersection is larger.
by bawolff 4y ago
Honestly im kind of surprised that they are even that close. I wonder if this changes at scale when the intersection is larger.
- Sirupsen 4y agoIdeally, I would add three graphs to the post: (1) Table size on the x-axis, and time on the y-axis for index merge vs composite index (2) Number of columns on the x-axis, and time on the y-axis for both (3) Number of final matches on the x-axis, and time on the y-axis for both But ran out of time and decided to test with the table size of 10M rows, and a 100-ish result set. That's in my experience a decent representation for what you might be doing with a relational database.