SQL Server Performance

How database optimization works

Discussion in 'Performance Tuning for DBAs' started by georgej, Apr 6, 2007.

  1. georgej New Member

    How database optimization works on SQL server 2000?
    Each time when I add new database files into my database or delete database files from the DB, does SQL server have to re-do optimization for the altered DB structure?
    If yes, does this impact the database perfromance?

    Thanks for assistance,


    George
  2. MohammedU New Member

    I don't think adding/removing the database file will change the query plan...
    Optimizer is more depends on indexes, statistics....

    When add/remove database files it will I/O...

    Statistics Used by the Query Optimizer in Microsoft SQL Server 2000
    http://msdn2.microsoft.com/en-us/library/aa902688(SQL.80).aspx

    SQL Server 2000 I/O Basics
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx



    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page