I have a lot of XMINs in my report in Cognos SQL and mins in the Native SQL...does that mean there would be a lot of local processing?
No - generally an XMIN in the Cognos SQL will be represented by a min() in the SQL sent to the database, so the work will be done within the database.
Cheers!
MF.