In compatibility mode, @@qpmode displays the query processing mode in which the previously executed query was processed. There are four query processing modes:
0 – a query that cannot be optimized; for example, create table, set, and so on.
1 – a query executed in full compatibility mode.
2 – a query executed in restricted compatibility mode.
3 – a query executed with the 15.0 query processor.
