Database developer, data engineer, Oracle Ace Pro β Born in Ukraine Views are my own
Joined November 2017
- Tweets225
- Following162
- Followers172
- Likes812
Andrej Pashchenko πΊπ¦ ππ retweeted
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β¦
Andrej Pashchenko πΊπ¦ ππ retweeted
ππ» 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
Andrej Pashchenko πΊπ¦ ππ retweeted
π£ HrOUG & JavaCro 2026 Call for Speakers is open!
Submit your talk or workshop and share your experience with the IT community.
π Mar 1 β May 31, 2026
π Rovinj, Croatia
π HrOUG: 2026.hroug.hr/eng/Call-for-pβ¦
π JavaCro: 2026.javacro.hr/eng/Call-forβ¦
#Java #Oracle #TechCommunity
Andrej Pashchenko πΊπ¦ ππ retweeted
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 πΊπ¦ ππ retweeted
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β¦
ALT The execution plans for NOT EXISTS and NOT IN queries. In both cases the Oracle optimizer is able to transform them into a null aware anti join
Andrej Pashchenko πΊπ¦ ππ retweeted
My @AccentureDACH colleague @Andrej_SQL is going to talk about partition exhange at the @Hroug_Croatia #HROUG2024 conference
@oracleace
Andrej Pashchenko πΊπ¦ ππ retweeted
Partition Exchange Reloaded by @Andrej_SQL at #hroug2024.
Andrej Pashchenko πΊπ¦ ππ retweeted
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
Andrej Pashchenko πΊπ¦ ππ retweeted
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 πΊπ¦ ππ retweeted
Inspired by @Andrej_SQL, here is another way to enable parameters in views, this time using a generic SQL macro:
stewashton.wordpress.com/202β¦
In 12 days I will be presenting about SQL macros at #apexconn24! Would you consider using SQM not as a replacement for views but as an addition that enables parameters, as described in my new blog post? Any feedback is greatly appreciated.
@oracleace
blog.sqlora.com/en/parameterβ¦
Andrej Pashchenko πΊπ¦ ππ retweeted
Ihr bekommt Euren πΊπ¦-Sticker beim Stand der @fellas4europe e. V. bei der #APEXconn24 vor Raum DΓΌsseldorf 1 + 2!
#orclAPEX β€οΈ
#StandWithUkraine πΊπ¦
Andrej Pashchenko πΊπ¦ ππ retweeted
SQL Macros were mentioned during this morningβs presentation. Now itβs time for a deep dive π€Ώ
Andrej Pashchenko πΊπ¦ ππ retweeted
Already available since @OracleDatabase 21c, but still new for many people in the audience: SQL Macros, explained by @Andrej_SQL at #DOAG2023
Andrej Pashchenko πΊπ¦ ππ retweeted
Trivadis Performance Days 2021 is scheduled as a hybrid event (in #Zurich and online) on October 26/27. This year's speakers are @ChandlerDBA @cshallahamer @davidmkurtz @JLOracle #RandolfEberleGeist @RogerMacNicol @dani_schnider and myself.
#tvdpdays
m.trivadis.com/performance-dβ¦
Andrej Pashchenko πΊπ¦ ππ retweeted
next stream #apexconn21 SQL Macros fΓΌr developers with @Andrej_SQL
Andrej Pashchenko πΊπ¦ ππ retweeted
The @Trivadis #PLSQL & #SQL Coding Guidelines v4.0 is now released:
HTML:
trivadis.github.io/plsql-andβ¦
PDF:
trivadis.github.io/plsql-andβ¦
What's new:
github.com/Trivadis/plsql-anβ¦
Enjoy π!
Thanks to @phsalvisberg for great support.
Andrej Pashchenko πΊπ¦ ππ retweeted
Query Rewrite: The Supreme League of Materialized Views with @dani_schnider #UKOUGConf20
Andrej Pashchenko πΊπ¦ ππ retweeted
Thank you @UKOUG for giving me the opportunity to speak about ORDS at #UKOUGConf20
Andrej Pashchenko πΊπ¦ ππ retweeted
#oracledatabase #oracle21 #autonomousdatabase #oraclecloud #freetier ... Start with the "Learning Database New Features" guide and try it out now ;)
docs.oracle.com/en/database/β¦
Andrej Pashchenko πΊπ¦ ππ retweeted
New post! Utilising SQL macros to create a nice clean html version of your data #oracle #19c
connor-mcdonald.com/2020/11/β¦