Details
-
New Feature
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
23.02, 23.10, 22.08(EOL)
-
None
-
None
Description
Sometimes queries runs slow , but suddenly runs fast without "order by" clause
or wrapping into a subselect like select * from (<select query>)
Even every case must be fixed , it should be a possibility to force the behaviour
of wrapping the query in a subselect, so application must not be changed,
so something like
columnstore_forced_subselect,
so simply set
set columnstore_forced_subselect = 1;
can work as a workarround,
Must be certainly dynamically and possible with global and session level.