InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:00:37 GMT20http://www.sqlservercentral.com/Forums/Topic769844-146-1.aspxDid you read those articles?Thu, 13 Aug 2009 05:01:00 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic769844-146-1.aspxthanks for replying gailbut how can i find which table require indexes and how to check wether indexes present in the tablefor performence tuning pls replyThu, 13 Aug 2009 04:36:42 GMTsivark1http://www.sqlservercentral.com/Forums/Topic769844-146-1.aspx[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]Thu, 13 Aug 2009 02:06:16 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic769844-146-1.aspxRun a trace for an hour or so during the busiest time of the day and feed the traced data to the index tuning wizard and see what it recommends. Other than that do all tables have primary keys? Clustered indexes?CEWIIWed, 12 Aug 2009 22:55:13 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic769844-146-1.aspxhi experts i have a database exixting 300 tables now i need to create indexes for the tables to increase performencepls suggest some good solutionsthanks in advanceWed, 12 Aug 2009 22:04:14 GMTsivark1