zikato / blogcomments

0 stars 0 forks source link

Scary Scalar Functions - Part One: Parallelism - StraightforwardSQL #18

Open utterances-bot opened 2 years ago

utterances-bot commented 2 years ago

Scary Scalar Functions - Part One: Parallelism - StraightforwardSQL

Consultants hate me for this one weird trick. Because I'll be uncovering all the mess Scalar functions can cause in a series of articles.

https://straightforwardsql.com/posts/scary-scalar-functions-parallelism/

andowero commented 2 years ago

If I understand correctly - when there is an UDF in a column or table check constraint, using this table in a SELECT query will prevent parallelism?