Most of my experience is with MySQL/MariaDB which created foreign key indexes behind your back.