Indexes and DML's performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Indexes and DML's performance

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    Indexes and DML's performance

    Does creating index on a coulmn that needs nd index
    have any performance impact on DML's like insert and delete
    statements? If yes can you please explain?

    Cheers,
    Randy

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: Indexes and DML's performance

    Originally posted by randy
    Does creating index on a coulmn that needs nd index
    have any performance impact on DML's like insert and delete
    statements? If yes can you please explain?

    Cheers,
    Randy
    it could, to what extent this is material to the time required for dml only you can answer.

    benchmark it and let us know you results
    I'm stmontgo and I approve of this message

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