Post reply

How to improve perfomance of given Query

  • August 22, 2009 at 5:36 am

    #203994

    Hi All,

    How to improve perfomance of given Query

    select * from table

    how we can otimized this query in respect of performance.

    thanks in Advance.

  • August 22, 2009 at 6:08 am

    #1043260

    From a SQL point of view, you can't improve the performance... selecting all columns from all rows in a table will just have to read all the pages allocated to that table. By selecting fewer columns or fewer rows you can improve the performance.

    The only way to improve the performance of that query is with hardware... faster I/O, more memory, faster CPU etc

  • August 22, 2009 at 8:07 am

    #1043269

    For the query you've mentioned, there cant be any performance improvement as Ian rightly said that all associated data pages will be read to return the resultset.

    However, if you're concerned about queries having a WHERE clause in them, you may want to consider creating indexes on those columns. Check out for the execution plan of those queries to have a look at the columns that require an index for faster querying.


    Pradeep Singh

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply