Either way I would say the system is gong to perform a table scan.  Kinda stinks but sounds like you're going to take a performance hit either way.

Could you possibly...

The answer to the first question is to use true temp tables instead of tables that you are just going to delete.  Place a pund symbol (#) in front of...