Results 1 to 21 of 21

Thread: [SQL Server] A column: to Index or not to Index

Threaded View

  1. #1

    Thread Starter
    Frenzied Member oceanebelle's Avatar
    Join Date
    Jun 2005
    Location
    my n00k.
    Posts
    1,064

    [SQL Server] A column: to Index or not to Index

    So I have a table with 3 columns, that can have hundreds of millions of rows.

    Now, I was wondering if removing 1 index from one column would impact the search time.

    Basically the query is like

    Code:
    select * from mytable where col1 = somevalue and col2 = someothervalue
    Currently, col1 and col2 has indices. Would it be alright to remove the index for col1?

    Removing both indices is a no no since searches crawls when that is done.

    Any enlightenment is highly appreciated.
    Last edited by oceanebelle; Apr 21st, 2009 at 12:03 PM.

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