Minimize Query Execution Time

Results 1 to 2 of 2

Thread: Minimize Query Execution Time

  1. #1
    Join Date
    Dec 1969

    Default Minimize Query Execution Time

    &nbsp;<BR>Hi,<BR><BR>I am using ASP and SQL Server 2000 for showing search results from database. <BR><BR>How to minimize the query execution time by using Full Text Indexing service of SQL Server 2000 or using simple sql with like clause if there are multiple tables are using in search query ?<BR><BR>What are the advantages and overheads of using Text based Indexing service?<BR><BR>Is there are any reference code / links from which I can find the solution for optimize search engine code in order to show results within minimum amount of time?<BR><BR>Thanks<BR><BR>Robert

  2. #2
    Join Date
    Dec 1969

    Default * Crosspost.

    Please read FAQ #110 on

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts