Andrej Pashchenko 🇺🇦 💙💛

219 posts

Andrej Pashchenko 🇺🇦 💙💛

Andrej Pashchenko 🇺🇦 💙💛

@Andrej_SQL

Database developer, data engineer, Oracle Ace Pro ♠ Born in Ukraine Views are my own

Katılım Kasım 2017
163 Takip Edilen170 Takipçiler
Andrej Pashchenko 🇺🇦 💙💛 retweetledi
SQL Daily
SQL Daily@sqldaily·
Storing UUIDs as RAW values is more efficient than strings But RAW can lead to implicit conversions => poor row estimates If you're stuck with string comparisons @Andrej_SQL shows how to improve row estimates with Extended stats Virtual columns blog.sqlora.com/en/fix-optimiz…
English
0
7
19
983
Martin Bach
Martin Bach@MartinDBA·
@Andrej_SQL @oracleace The entire family of `returning into` clauses has been enhanced in Oracle Database 23ai. You get old and new values for insert, update and delete in addition to merge.
English
1
0
4
92
Andrej Pashchenko 🇺🇦 💙💛 retweetledi
SQL Daily
SQL Daily@sqldaily·
Get rows in one table with no match in another with either c1 NOT IN ( SELECT c2 ... ) NOT EXISTS ( SELECT ... where c1 = c2 ) These perform the same in Oracle #SQL ...unless C2 includes NULL values => NOT IN returns no rows! @Andrej_SQL explores blog.sqlora.com/en/not-in-vs-n…
SQL Daily tweet media
English
0
16
76
3.1K
Andrej Pashchenko 🇺🇦 💙💛
And if you want to use your existing views and let SQL macros "inject" parameter, you can check the second part (blog.sqlora.com/en/parameteriz…) of this post and also @StewAshton 's post: stewashton.wordpress.com/2024/04/24/sql…
SQL Daily@sqldaily

Views are great for creating reusable #SQL statements But they have a drawback: you can't pass parameters to them! @Andrej_SQ shows how to emulate these with SQL macros in Oracle Database Use these to create parameterized query templates blog.sqlora.com/en/parameteriz…

English
0
1
4
246