The reason I asked about the FKs is that the database has 1300 tables and almost 2000 FKs...

From the referenced tables we have, mandatory, almost 500 unique indexes...

Having the reference table indexes means adding 2000 new indexes (probably 400 or 500 are already there on existing indexes, just reorganize columns and voila) but at least 1500 new indexes would be added...

My plan is to create a job, or regularly check myself, with a query that checks for reference tables on FKs without index but both tables (reference and referenced) must have records and the reference table at least 20 pages... Is this a good approach, instead of creating on the fly the 1500 new indexes?! If the tables don't have any data the indexes will be empty also but no unnecessary indexes on the database....

Thanks,

Pedro