Think you know about #SQL performance?
Take this 3-minute indexing quiz by Markus Winand
A simple test that 60% fail!
https://lnkd.in/ejRx5pbn
Did you pass? Let us know how you did!
54
Chris Saxon
Tech & AI
2mo
Should these functions return the same value?
SELECT
ROW_NUMBER() OVER (ORDER BY x),
ROW_NUMBER() OVER (ORDER BY x)
FROM ...
What about when many rows have the same value for X?
According to the #SQL standard: yes
Markus Winand investigates
37
Chris Saxon
Tech & AI
4mo
Think you know about #SQL performance?
Take this 3-minute indexing quiz by Markus Winand
A simple test that 60% fail!
https://lnkd.in/ejRx5pbn
Did you pass? Let us know how you did!
54
Chris Saxon
Tech & AI
2mo
Should these functions return the same value?
SELECT
ROW_NUMBER() OVER (ORDER BY x),
ROW_NUMBER() OVER (ORDER BY x)
FROM ...
What about when many rows have the same value for X?
According to the #SQL standard: yes
Markus Winand investigates
37
Chris Saxon
Tech & AI
4mo
Think you know about #SQL performance?
Take this 3-minute indexing quiz by Markus Winand
A simple test that 60% fail!
https://lnkd.in/ejRx5pbn
Did you pass? Let us know how you did!
54
Chris Saxon
Tech & AI
2mo
Should these functions return the same value?
SELECT
ROW_NUMBER() OVER (ORDER BY x),
ROW_NUMBER() OVER (ORDER BY x)
FROM ...
What about when many rows have the same value for X?
According to the #SQL standard: yes
Markus Winand investigates