Andrej Pashchenko ๐บ๐ฆ ๐๐
@Andrej_SQL
Database developer, data engineer, Oracle Ace Pro โ Born in Ukraine Views are my own
๋ด๊ฐ ์ข์ํ ๋งํ ์ฝํ ์ธ
New post for #JoelKallmanDay! Ever wondered why the Oracle Optimizer sometimes ignores your histograms? Implicit data type conversions might be to blame. Hereโs how to fix it without touching your SQL and with minimal schema impact. #Oracledatabase blog.sqlora.com/en/fix-optimizโฆ
Honored to speak at #HROUG2025 โ celebrating its 30th anniversary in amazing Rovinj!๐Huge thanks to the organizers for keeping this fantastic community going for 30 years!๐ Letโs put some old SQL myths to the test together! #Oracle #SQL #Optimizer #Accenture #OracleAce
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 @oracleace blog.sqlora.com/en/merge-and-dโฆ
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 @oracleace blog.sqlora.com/en/ora-30926-iโฆ
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 @oracleace blog.sqlora.com/en/when-compreโฆ
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โฆ
My @AccentureDACH colleague @Andrej_SQL is going to talk about partition exhange at the @Hroug_Croatia #HROUG2024 conference @oracleace
Partition Exchange Reloaded by @Andrej_SQL at #hroug2024.
Everything you should know about block corruptions in #Oracledatabase with @CGohmannDE at #hroug2024
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
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โฆ
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โฆ
I am absolutely thrilled to be presenting at the #HROUG2024 for the first time. Thanks @Hroug_Croatia for accepting my talks. In just two weeks! See you there! @oracleace
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 @oracleace blog.sqlora.com/en/online-statโฆ
Join AOUG Anwenderkonferenz 2024 next week for many great sessions presented by Oracle ACEs ๐ @alexnuijten @Ambili_Thots @Andrej_SQL @JrgDoppelreiter @martinberger_ch @Mirela_RoOUG @RoelH @rsantrod @oraclesean @stefanoehrli social.ora.cl/60105VSQq #OracleACE
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 @oracleace blog.sqlora.com/en/object-statโฆ
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โฆ @oracleace
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
United States ํธ๋ ๋
- 1. Flacco 83.1K posts
- 2. Bengals 79.4K posts
- 3. Bengals 79.4K posts
- 4. Tomlin 21.5K posts
- 5. Ramsey 18.6K posts
- 6. Chase 106K posts
- 7. Chase 106K posts
- 8. #TNFonPrime 5,524 posts
- 9. #WhoDey 6,752 posts
- 10. #WhoDidTheBody 1,459 posts
- 11. Teryl Austin 2,731 posts
- 12. #clubironmouse 2,085 posts
- 13. Cuomo 80.4K posts
- 14. #criticalrolespoilers 6,623 posts
- 15. Andrew Berry 3,182 posts
- 16. Max Scherzer 14.1K posts
- 17. DK Metcalf 3,930 posts
- 18. Burrow 9,650 posts
- 19. Ace Frehley 95.4K posts
- 20. yeonjun 105K posts
Something went wrong.
Something went wrong.