Experiment on performance: SELECT SINGLE vs FOR ALL ENTRIES, secondary index access

Experiment on performance series

Part I: SELECT SINGLE vs FOR ALL ENTRIES

Part II: SELECT SINGLE vs FOR ALL ENTRIES, secondary index access

I believe our previous test on SELECT SINGLE vs FOR ALL ENTRIES did not surprise many of you because I see a tendency towards FOR ALL ENTRIES┬áin programs I encounter. In previous scenario, we were able to access the search table with primary key but this may not be the case every time. Let’s see what happens if we could not access the search table with primary key, but with secondary index. Continue reading “Experiment on performance: SELECT SINGLE vs FOR ALL ENTRIES, secondary index access”