Home Forums SQL Server 7,2000 T-SQL How to Reduce the Logical Reads, to imporve the Performance of the Query RE: How to Reduce the Logical Reads, to imporve the Performance of the Query

  • September 17, 2008 at 10:53 pm

    #873383

    santoooo (9/17/2008)

    So, to reduce the Logical Reads we need proper indexing for the tables.

    Regards,

    Santosh

    No, you need proper database.

    Proper schema, proper data normalisation, proper data types, proper keys, proper indexes, etc.

    You need to open a good book about relational DB design and follw its recommendations.

    _____________
    Code for TallyGenerator