Search Engine SQL query

[bsatheesh]

Hi,

We have a set of tables which has information on which we need to search for certain items. For that I need to use many joins to fetch certain data from millions of records. The query normally contains 'LIKE' statement to mach the string.
Is there any specific query tuning stuff available for search engines to reduce the query execution time?

thanks,
Satheesh.

[chrisrlong]

Sorry, but this question is simply far too broad.

First, you must have an optimal database design. There are dozens, if not hundreds, of rules to be followed to make sure that this is true.

You then construct the SQL to obtain any given set of information. There are then dozens of rules to follow to make sure that the SQL is optimal as well.

So for a question as general as what you have asked, there are 2 general answers:

- Make sure you have an optimal design
- Make sure you write optimal SQL.

If you have more specific questions along the way, feel free to ask them.

- Chris