i am using MS Sql Server 2005. In this server a database is there which have little bit large amount of data in this database structure more then 100 of tables are available. i already created Primary and Foreign keys to all my related tables.
now my problem is that when i run any query which has more conditions with near about approximate from 6 to 8 tables at that time the CPU Usage will go to 100%.
Please Need Help,
thanks in advance.