--4)/*Basically Companies or Contacts can be the owners of Products. Sometimes I want to bring back all the Products that a company owns - including that of all it's contacts.This DML attempt runs quick, but I don't think it scales up to the amount of records I mention above.*/

I tried indexes on CON_DepartmentID and BAS_ProductID and it actually slowed it down - probably because the optimizer had to choose between indexes, not sure.More than 99% of the records have PRO_OwnerID as the same value. So I'm going to try a partition on the Products table and put that PRO_OwnerID in as a constraint on one of the two tables and then use a view. We'll see if that fixes it.