MySQL
Oracle
PostgreSQL
before partitioning
after partitioning
what you can query
shop
├── orders
table
└── sales
table
├── p2022
partition, not a table
└── p2023
partition, not a table
on disk
/var/lib/mysql/shop/
├── orders.ibd
own file
├── sales#p#p2022.ibd
own file
└── sales#p#p2023.ibd
own file
Hover a name to see which files hold it. Run on MySQL 8.0.46 (docker).