InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:12:48 GMT20http://www.sqlservercentral.com/Forums/Topic925706-146-1.aspxpretty simple query. Not much SQL to tune.looks like building a nonclustered index on mode will help this query a great deal.Be cautious when adding indices, as they slow down write performance (slightly) and require continued maintenance. Before building an index, make sure you have enough disk space to hold all the data in the mode column, plus the PK column.refactoring the query to not be a select * might help too, but then you'd select only the columns you want to use and build a covering index with the first column of mode. That would make the query the fastest, but would cost the most in terms of disk space and write performance.~cFri, 21 May 2010 07:35:07 GMTSQLBOThttp://www.sqlservercentral.com/Forums/Topic925706-146-1.aspxPlease post the query, table definitions and index definitions as per [url]http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Fri, 21 May 2010 04:25:50 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic925706-146-1.aspxAs far as I can see, your queryselect top 100 * from dbo.StockLocationLog where mode='Dispatch' - it's a "select all" query - if there is any ndex on the "mode" column, it may not be selective enough.Can you send the table definition, indexes included?Fri, 21 May 2010 04:21:28 GMTdmoldovanhttp://www.sqlservercentral.com/Forums/Topic925706-146-1.aspxHi,I have select query which taking too much time to retrieve data from DB.How can optimize that query.I try full text search tech also.but it doesn`t work for me I am attaching excution plan for the queryPlz. HelpThanks in AdvanceFri, 21 May 2010 01:05:16 GMTTrouble Shooter