Dani Schnider
@danischnider.bsky.social
Oracle Databases, Data Warehousing, SQL Performance Tuning, Oracle ACE Director.
Craft Beer Brewing, Beer Sommelier.
Craft Beer Brewing, Beer Sommelier.
Reposted by Dani Schnider
How do the data types of join columns affect query performance?
@danischnider.bsky.social compares using
Hashes as CHAR(32) and RAW(16)
Sequences as NUMBER
And finds in Oracle #SQL
NUMBER is faster than RAW
RAW is faster than CHAR
@danischnider.bsky.social compares using
Hashes as CHAR(32) and RAW(16)
Sequences as NUMBER
And finds in Oracle #SQL
NUMBER is faster than RAW
RAW is faster than CHAR
Data Types of Join Columns
The data type of primary key and foreign key columns has an impact on the query performance. This should be considered in the design decision of keys in a Data Vault schema.
buff.ly
November 20, 2025 at 12:01 PM
How do the data types of join columns affect query performance?
@danischnider.bsky.social compares using
Hashes as CHAR(32) and RAW(16)
Sequences as NUMBER
And finds in Oracle #SQL
NUMBER is faster than RAW
RAW is faster than CHAR
@danischnider.bsky.social compares using
Hashes as CHAR(32) and RAW(16)
Sequences as NUMBER
And finds in Oracle #SQL
NUMBER is faster than RAW
RAW is faster than CHAR
Full room at the „Fun with SQL“ session of @andreakennel.bsky.social at #DOAG2025
November 20, 2025 at 9:13 AM
Full room at the „Fun with SQL“ session of @andreakennel.bsky.social at #DOAG2025
Reposted by Dani Schnider
If you love your data then you have to love this feature. Presented by @toonkoppelaars.bsky.social who joined Oracle to make that happen. #DOAG2025
November 19, 2025 at 8:00 AM
If you love your data then you have to love this feature. Presented by @toonkoppelaars.bsky.social who joined Oracle to make that happen. #DOAG2025
Reposted by Dani Schnider
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
November 19, 2025 at 8:23 AM
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
Reposted by Dani Schnider
Learning from mistakes is important. Better: learn from others' mistakes. Even better: today we can learn from @danischnider.bsky.social 's ones #doag2025
November 18, 2025 at 10:07 AM
Learning from mistakes is important. Better: learn from others' mistakes. Even better: today we can learn from @danischnider.bsky.social 's ones #doag2025
Reposted by Dani Schnider
🎤 Don’t miss DOAG Konferenz + Ausstellung 2025 — Nov 18–21, the premier event for database technologies in the German-speaking region!
Join #OracleACE experts and industry leaders for in-depth sessions on Oracle tech, modern IT trends, open source, and more. 👉 anwenderkonferenz.doag.org/de/home/
Join #OracleACE experts and industry leaders for in-depth sessions on Oracle tech, modern IT trends, open source, and more. 👉 anwenderkonferenz.doag.org/de/home/
November 14, 2025 at 9:43 AM
🎤 Don’t miss DOAG Konferenz + Ausstellung 2025 — Nov 18–21, the premier event for database technologies in the German-speaking region!
Join #OracleACE experts and industry leaders for in-depth sessions on Oracle tech, modern IT trends, open source, and more. 👉 anwenderkonferenz.doag.org/de/home/
Join #OracleACE experts and industry leaders for in-depth sessions on Oracle tech, modern IT trends, open source, and more. 👉 anwenderkonferenz.doag.org/de/home/
Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post:
danischnider.wordpress.com/2025/10/24/q...
danischnider.wordpress.com/2025/10/24/q...
QUALIFY: The WHERE Condition for Analytic Functions
Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for an…
danischnider.wordpress.com
October 24, 2025 at 2:35 PM
Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post:
danischnider.wordpress.com/2025/10/24/q...
danischnider.wordpress.com/2025/10/24/q...
Reposted by Dani Schnider
Exciting to see Oracle ACEs featured as speakers at SOUG Day Zurich 2025 on October 23! 🇨🇭✨ Get ready for a day full of expert insights and networking with the Swiss Oracle community.
Discover more:
🔗 soug.ch/event/soug-day-zurich-2025/
@helifromfinland.bsky.social @danischnider.bsky.social
Discover more:
🔗 soug.ch/event/soug-day-zurich-2025/
@helifromfinland.bsky.social @danischnider.bsky.social
October 22, 2025 at 6:28 AM
Exciting to see Oracle ACEs featured as speakers at SOUG Day Zurich 2025 on October 23! 🇨🇭✨ Get ready for a day full of expert insights and networking with the Swiss Oracle community.
Discover more:
🔗 soug.ch/event/soug-day-zurich-2025/
@helifromfinland.bsky.social @danischnider.bsky.social
Discover more:
🔗 soug.ch/event/soug-day-zurich-2025/
@helifromfinland.bsky.social @danischnider.bsky.social
A funny last session at #HrOUG2025 with SELECT AI Funhouse and @kibeha.dk
October 18, 2025 at 9:04 AM
A funny last session at #HrOUG2025 with SELECT AI Funhouse and @kibeha.dk
Last day at #HrOUG2025 starts with @salvis.com fighting with bad code
October 18, 2025 at 7:57 AM
Last day at #HrOUG2025 starts with @salvis.com fighting with bad code
Fundamentals of Oracle security (and some drinks) with @chandlerdba.bsky.social at #HrOUG2025
October 17, 2025 at 9:02 AM
Fundamentals of Oracle security (and some drinks) with @chandlerdba.bsky.social at #HrOUG2025
Basic knowhow that every Oracle developer and DBA should know: how do transactions work in an Oracle database. @martinklierdba.bsky.social explains it in detail at #HrOUG2025
October 16, 2025 at 3:19 PM
Basic knowhow that every Oracle developer and DBA should know: how do transactions work in an Oracle database. @martinklierdba.bsky.social explains it in detail at #HrOUG2025
Reposted by Dani Schnider
This is how a latch contention looks in real life. The @ora600pl.bsky.social way at #HrOUG2025
October 16, 2025 at 2:08 PM
This is how a latch contention looks in real life. The @ora600pl.bsky.social way at #HrOUG2025
So many slides on a session of @ora600pl.bsky.social ? Something must be wrong here. Let‘s see…
#HrOUG2025
#HrOUG2025
October 16, 2025 at 1:54 PM
So many slides on a session of @ora600pl.bsky.social ? Something must be wrong here. Let‘s see…
#HrOUG2025
#HrOUG2025
After lunch break session at #HrOUG2025 about CI/CD using #SQLcl, presented by @apexconsulting.nl (with a very nice t-shirt, by the way)
October 16, 2025 at 1:07 PM
After lunch break session at #HrOUG2025 about CI/CD using #SQLcl, presented by @apexconsulting.nl (with a very nice t-shirt, by the way)
If you are at #HrOUG2025 and don‘t speak Croatian, you are probibly interested in this additional session tomorrow
October 16, 2025 at 12:39 PM
If you are at #HrOUG2025 and don‘t speak Croatian, you are probibly interested in this additional session tomorrow
Quiet moment during the #HrOUG2025 conference
October 16, 2025 at 11:12 AM
Quiet moment during the #HrOUG2025 conference
Reposted by Dani Schnider
Lot if interest in deep diving into performance of views by @danischnider.bsky.social at #HrOUG2025
October 16, 2025 at 9:57 AM
Lot if interest in deep diving into performance of views by @danischnider.bsky.social at #HrOUG2025
#HrOUG2025
@fsarcos.bsky.social talks about dragons and PDB failover approaches in Oracle 23ai (aka 26ai)
@fsarcos.bsky.social talks about dragons and PDB failover approaches in Oracle 23ai (aka 26ai)
October 16, 2025 at 9:16 AM
#HrOUG2025
@fsarcos.bsky.social talks about dragons and PDB failover approaches in Oracle 23ai (aka 26ai)
@fsarcos.bsky.social talks about dragons and PDB failover approaches in Oracle 23ai (aka 26ai)
I still like this session of chandlerdba.bsky.social about Exadata alternatives and why Exadata is still the cheapest and best solution.
Once again at #HrOUG2025
Once again at #HrOUG2025
October 16, 2025 at 9:10 AM
I still like this session of chandlerdba.bsky.social about Exadata alternatives and why Exadata is still the cheapest and best solution.
Once again at #HrOUG2025
Once again at #HrOUG2025
October 15, 2025 at 2:35 PM
Almost there… #HrOUG2025
Just arrived in Rovinj in time thanks to the professional „Grisselbav Tours“ driver @salvis.com with co-pilot @andreakennel.bsky.social
Just arrived in Rovinj in time thanks to the professional „Grisselbav Tours“ driver @salvis.com with co-pilot @andreakennel.bsky.social
October 15, 2025 at 12:55 PM
Almost there… #HrOUG2025
Just arrived in Rovinj in time thanks to the professional „Grisselbav Tours“ driver @salvis.com with co-pilot @andreakennel.bsky.social
Just arrived in Rovinj in time thanks to the professional „Grisselbav Tours“ driver @salvis.com with co-pilot @andreakennel.bsky.social
Reposted by Dani Schnider
@danischnider.bsky.social erzählt uns in einem Kurz-Interview von seiner großen Begeisterung für die #DOAG2025 in Nürnberg. ➡️ scomp.ly/jPg3bBb
Die Anwenderkonferenz
📍DOAG 2025 Konferenz + Ausstellung | Nürnberg Convention Center
📅 18.–21. November 2025
🔗Anmeldung | scomp.ly/YAj48bE
Die Anwenderkonferenz
📍DOAG 2025 Konferenz + Ausstellung | Nürnberg Convention Center
📅 18.–21. November 2025
🔗Anmeldung | scomp.ly/YAj48bE
October 14, 2025 at 11:12 AM
@danischnider.bsky.social erzählt uns in einem Kurz-Interview von seiner großen Begeisterung für die #DOAG2025 in Nürnberg. ➡️ scomp.ly/jPg3bBb
Die Anwenderkonferenz
📍DOAG 2025 Konferenz + Ausstellung | Nürnberg Convention Center
📅 18.–21. November 2025
🔗Anmeldung | scomp.ly/YAj48bE
Die Anwenderkonferenz
📍DOAG 2025 Konferenz + Ausstellung | Nürnberg Convention Center
📅 18.–21. November 2025
🔗Anmeldung | scomp.ly/YAj48bE
Reposted by Dani Schnider
Datenbankpannen made in Switzerland: Von DropTable bis Split-Brain – Teil 2 unserer DOAGtv-Geschichten mit Martin Klier, @stefanoehrli.bsky.social und @danischnider.bsky.social zeigt, wie Recovery-Nächte auch mal mit Pizza enden ➡️ scomp.ly/Y3DVQmY
September 30, 2025 at 8:37 AM
Datenbankpannen made in Switzerland: Von DropTable bis Split-Brain – Teil 2 unserer DOAGtv-Geschichten mit Martin Klier, @stefanoehrli.bsky.social und @danischnider.bsky.social zeigt, wie Recovery-Nächte auch mal mit Pizza enden ➡️ scomp.ly/Y3DVQmY
Reposted by Dani Schnider
Von #SQL-Horror bis Dialekt-Wirrwarr: Die erfahrenen Oracle-Experten und ACEs @stefanoehrli.bsky.social, @danischnider.bsky.social und Martin Klier sprechen im DOAGtv 🎥 über #Datenbank Pannen, #Performance Fallen und wie Humor beim #Recovery hilft.
Teil 1/2 ➡️ youtu.be/a8uolY6Or1U
Teil 1/2 ➡️ youtu.be/a8uolY6Or1U
Zwischen Linux-Fallen und Virenscanner-Schocks: Datenbankgeschichten aus der Schweiz
YouTube video by doagtv
youtu.be
September 19, 2025 at 8:19 AM
Von #SQL-Horror bis Dialekt-Wirrwarr: Die erfahrenen Oracle-Experten und ACEs @stefanoehrli.bsky.social, @danischnider.bsky.social und Martin Klier sprechen im DOAGtv 🎥 über #Datenbank Pannen, #Performance Fallen und wie Humor beim #Recovery hilft.
Teil 1/2 ➡️ youtu.be/a8uolY6Or1U
Teil 1/2 ➡️ youtu.be/a8uolY6Or1U