How to make database sql query run faster?

1>split into different tables 2>make index 3>use stored procedure and trigger on the database

Most databases will have some type of EXPLAIN PLAN function. This function will run your SQL and map out the steps the SQL takes to read each table in the query and identify how each is parsed (full scan, indexed scan etc) and what order they are read. This let's you improve the performance of the SQL by identifying a better way to write your SQL (different table order, different join criteria) or improvements to the table indexing. You can also get third party products that analyse and improve SQL. Have a look at Quest Software as an example.

First you must have the system speed higher and then your server executing the sql commands must be loaded with less traffic. Second eventually your database must be split in many tables using smaller no. of tables at a time. :)

lots of ways !!! ..index relevant columns ..refresh indexes, if out of date ..re-look at your query depends on what is ur database and on the funny side... remove some data...that will definitely speed up queries.. no data shud give u the fastest ..