Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›

@andrej_sql

Database developer, data engineer, Oracle Ace Associate β™ 
Born in Ukraine
Views are my own

ID: 927198037654540288

linkhttps://blog.sqlora.com calendar_today05-11-2017 15:36:53

210 Tweet

168 Followers

159 Following

Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile Photo

Thanks DOAG e.V. and organizing team for this awesome 10th #apexconn24 conference. And thanks to all attendies for your attention and feedback. I hope @josifabr and I could convince a few more people to check out #sqlmacros

Thanks <a href="/DOAGeV/">DOAG e.V.</a> and organizing team for this awesome 10th #apexconn24 conference. And thanks to all attendies for your attention and feedback. I hope @josifabr and I could convince a few more people to check out #sqlmacros
DOAG e.V. (@doagev) 's Twitter Profile Photo

Der Call for Papers für die DOAG 2024 Konferenz + Ausstellung ist erâffnet! Bis zum 3. Juni kânnt ihr ab sofort eure BeitrÀge einreichen und das Programm der großen Anwenderkonferenz aktiv mitgestalten. Wir freuen uns auf eure Einreichungen! #DOAG2024 scomp.ly/PbORz5G

Der Call for Papers für die DOAG 2024 Konferenz + Ausstellung ist erâffnet! Bis zum 3. Juni kânnt ihr ab sofort eure BeitrÀge einreichen und das Programm der großen Anwenderkonferenz aktiv mitgestalten. Wir freuen uns auf eure Einreichungen! #DOAG2024 scomp.ly/PbORz5G
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile Photo

I will talk about optimizer statistics at #AOUG Conference on June 17th, in particular what my responsibilities as a data engineer are. I think it's very important that it's not seen as just a DBA's job. Here is just one simple example of why: blog.sqlora.com/en/object-stat… Oracle ACE Program

Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile Photo

As a data engineer, do I have to worry about optimizer statistics? In the second part is a typical example of why the performance immediately after loading the data can be suboptimal if you don't take care of the stats. #oracledatabase Oracle ACE Program blog.sqlora.com/en/object-stat…

Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile Photo

There have been some changes and improvements to the Online Statistics Gathering for Bulk Loads over the last few years. Here is the new blog post: #oracledatabase Oracle ACE Program blog.sqlora.com/en/online-stat…

Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile Photo

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 Stew Ashton 's post: stewashton.wordpress.com/2024/04/24/sql…

Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile Photo

On this #JoelKallmanDay, I would like to follow up on my last year's post, comparing #SQL’s NOT IN and NOT EXISTS, focusing on their usage, interchangeability and some myths about performance differences. blog.sqlora.com/en/not-in-vs-n… #Oracledatabase

SQL Daily (@sqldaily) 's Twitter Profile Photo

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 Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› explores blog.sqlora.com/en/not-in-vs-n…

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 =&gt; NOT IN returns no rows!

<a href="/Andrej_SQL/">Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’›</a> explores blog.sqlora.com/en/not-in-vs-n…
Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile Photo

Did you know that refreshing HCC-compressed materialized views with atomic_refresh=true can multiply storage usage over time? Small details can have massive impacts. Read the new blog post. #Exadata #Oracle #HCC Oracle ACE Program blog.sqlora.com/en/when-compre…

Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile Photo

Ten years after my first post on the quirks of MERGE and ORA-30926, I took a fresh look at how Oracle 23ai handles it. Clearer error messages, improved diagnostics, and fewer unnecessary restarts. Read the new blog post #Oracle23ai #SQL #MERGE Oracle ACE Program blog.sqlora.com/en/ora-30926-i…

Andrej Pashchenko πŸ‡ΊπŸ‡¦ πŸ’™πŸ’› (@andrej_sql) 's Twitter Profile Photo

MERGE ... RETURNING is now supported in #Oracle23ai. In my view, it deserves more visibility in the documentation β€” it wasn’t easy to find. Even LLMs still claim it doesn’t exist (some even invent error codes). #SQL #MERGE Oracle ACE Program blog.sqlora.com/en/merge-and-d…