Performance - Indexes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Performance - Indexes

  1. #1
    Join Date
    Sep 2000
    Location
    Singapore
    Posts
    32
    Hi,

    I know that more number of indexes will degrade the performance of the SQL and database. But can anyone explain me how and why, I think more index will reduce the performance of the of Updation, am i correct.

    Thanks in Advance
    Felix
    DBA

  2. #2
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    if your update statement includes a column on which there exsists an index , then apart from updating the Table segment the corresponding index segments are also updated, this might lead to total or partial restructuring of the index....hence increasing indexes might adversely affect updation.
    Suvashish

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width