I have been wondering what would put less overhead in the database: a single very long query that would end up joining up to 3 tables with millions of records each or split it up into several queries?

just curious

thanks in advance