Why do I get different query plans for the same query?

The query processor may return a different query plan depending on whether you configure set plan optgoal for allrows_oltp, allrows_mix, or allrows_dss (unless you force a plan with forceplan):