Results 1 to 3 of 3

Thread: Table Delete

  1. Nov 16th, 2009, 12:42 PM #1
    gb1983
    gb1983 is offline

    Thread Starter
    Lively Member
    Join Date
    Dec 2008
    Posts
    103

    Table Delete

    Hi,

    If I delete rows from a table which contains a non-clustered index, how is the index affected during this process? E.g. Do the remaining index pointers need to be updated to reference rows that have not been deleted etc.

    Also does adding an index make a delete operation perform better?

    Thanks.
    Reply With Quote Reply With Quote
  2. Nov 16th, 2009, 02:04 PM #2
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Re: Table Delete

    If you're deleting the entire table, the index might end up slowing down the operation.
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog
    Reply With Quote Reply With Quote
  3. Nov 20th, 2009, 01:05 AM #3
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Table Delete

    Indexes are for optimizing searches, it can slow down data manipulation operations though.
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width