Why does the query optimer choose a serial plan when filter made less restrictive
I’m working through Iztik Ben-Gan book T-SQL Querying.
I have some trouble understanding why making a filter less restrictive will make the optimzer move away from a parallel plan to a serial one.
Why does the query optimer choose a serial plan when filter made less restrictive
I’m working through Iztik Ben-Gan book T-SQL Querying.
I have some trouble understanding why making a filter less restrictive will make the optimzer move away from a parallel plan to a serial one.
Why does the query optimer choose a serial plan when filter made less restrictive
I’m working through Iztik Ben-Gan book T-SQL Querying.
I have some trouble understanding why making a filter less restrictive will make the optimzer move away from a parallel plan to a serial one.
Why does the query optimer choose a serial plan when filter made less restrictive
I’m working through Iztik Ben-Gan book T-SQL Querying.
I have some trouble understanding why making a filter less restrictive will make the optimzer move away from a parallel plan to a serial one.