←
Andrej Pashchenko 🇺🇦 💙💛225 posts
Andrej Pashchenko 🇺🇦 💙💛 avatar

Andrej Pashchenko 🇺🇦 💙💛

@Andrej_SQL

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

◷ Joined November 2017▧ 49 Photos and videos
Andrej Pashchenko 🇺🇦 💙💛 avatar
Andrej Pashchenko 🇺🇦 💙💛@Andrej_SQL·Oct 14

#joelkallmanday #oracle26ai introduces QUALIFY — a welcome addition to Oracle SQL that makes filtering on analytic function results much easier. But what happens under the hood? Query transformations and execution plans reveal a few surprises. blog.sqlora.com/en/oracle-26…

Andrej Pashchenko 🇺🇦 💙💛 avatar
Andrej Pashchenko 🇺🇦 💙💛@Andrej_SQL·Aug 24

A very good question on my first Oracle 26ai JOIN TO ONE post made me look even closer. This time: the real CBO transformations behind the implicit LEFT OUTER JOIN — and the performance impact of the runtime checks. blog.sqlora.com/en/oracle-26… #oracle26ai #sql

A few months ago, Oracle 26ai introduced the new JOIN TO ONE syntax. After a first look during one of my Oracle 26ai trainings, I wanted to explore it further from a data warehouse perspective. Thoughts and experiments: blog.sqlora.com/en/oracle-26… #oracle26ai #sql #datawarehouse

Andrej Pashchenko 🇺🇦 💙💛 avatar
Andrej Pashchenko 🇺🇦 💙💛@Andrej_SQL·Aug 19

A few months ago, Oracle 26ai introduced the new JOIN TO ONE syntax. After a first look during one of my Oracle 26ai trainings, I wanted to explore it further from a data warehouse perspective. Thoughts and experiments: blog.sqlora.com/en/oracle-26… #oracle26ai #sql #datawarehouse

SQL Daily avatar
⟳ Andrej Pashchenko 🇺🇦 💙💛 retweeted
SQL Daily@sqldaily·Jul 24

With online stats gathering, Oracle AI Database captures stats when you use CREATE TABLE AS SELECT A direct path INSERT INTO ... SELECT into an empty table @Andrej_SQL investigates its evolution And finds many restrictions are lifted 26ai blog.sqlora.com/en/online-st…

Oracle ACE Program avatar
⟳ Andrej Pashchenko 🇺🇦 💙💛 retweeted
Oracle ACE Program@oracleace·May 22

🌊💻 MakeIT 2026 & JCON Slovenia 2026 are almost here! Join the Oracle, Java, and open-source community in Portorož, Slovenia for three exciting days of learning, innovation, and networking. 🚀 We’re excited to see Oracle ACEs sharing their expertise and connecting with the international tech community throughout the conference! 📍 Portorož, Slovenia | 📅 May 27–29, 2026 🔗 social.ora.cl/6019BBSYwz Looking forward to inspiring sessions, hands-on workshops, and amazing community energy by the Adriatic coast! 🙌 @AndrevanderPut @Andrej_SQL @danischnider @erikvanroon @gianniceresa @gilsonsm @kamil_stawiars @LucasJellema @MarcinDBA @thecodergal @commi235 @ChandlerDBA @patrickjollif1 @PetarSimic @rhjmartens @RustamMehmand1 @uzhnik @ziga_vaupot @zorantica @OyvindIsene #oracleace

Post attachment
Andrej Pashchenko 🇺🇦 💙💛 avatar
Andrej Pashchenko 🇺🇦 💙💛@Andrej_SQL·Feb 20

New short blog series on Oracle 26ai CALENDAR functions. Part 2: execution context and the question — Do I still need a time dimension? #oracle #sql #26ai #datawarehouse blog.sqlora.com/en/calendar-…

SQL Daily avatar
⟳ Andrej Pashchenko 🇺🇦 💙💛 retweeted
SQL Daily@sqldaily·4 Nov 2025

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-optim…

Andrej Pashchenko 🇺🇦 💙💛 avatar
Andrej Pashchenko 🇺🇦 💙💛@Andrej_SQL·14 Oct 2025

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-optim…

Andrej Pashchenko 🇺🇦 💙💛 avatar
Andrej Pashchenko 🇺🇦 💙💛@Andrej_SQL·8 May 2025

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…

Andrej Pashchenko 🇺🇦 💙💛 avatar
Andrej Pashchenko 🇺🇦 💙💛@Andrej_SQL·22 Apr 2025

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…

Andrej Pashchenko 🇺🇦 💙💛 avatar
Andrej Pashchenko 🇺🇦 💙💛@Andrej_SQL·6 Jan 2025

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-comp…

SQL Daily avatar
⟳ Andrej Pashchenko 🇺🇦 💙💛 retweeted
SQL Daily@sqldaily·29 Oct 2024

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…

Post attachment