Results 1 to 4 of 4

Thread: Index Selection

  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    2

    Unanswered: Index Selection

    Assume table T with columns: i binary, j int, k int, x varchar(5), y varchar(10).
    Following are the indexes that this table have on it:
    Idx1 on columns i,j,x
    Idx2 on columns i,k,x
    Idx3 on columns i,j,y
    Idx4 on columns i,k,y
    Note that the leading column in all the indexes is 'i'. There are different queries whose where clauses include conditions on columns (i,j,x), (i,k,x), (i,j,y) and (i,k,y). These queries select around 10-20% of the total no. of rows.
    As we are maintaining 4 indexes, DML operations are taking longer time to process. If we drop all these indexes and create another one, say Idx on columns i,j,k,x,y - does this going to have any(too much) -ve effect on my SELECT queries?

    Thanks in advance,
    Prashanth.

  2. #2
    Join Date
    Jun 2003
    Posts
    140

    Re: Index Selection

    I dont think there will be negative effects if u do so and
    yes there will be surely advantage of maintaining
    less indexes while updating

  3. #3
    Join Date
    Mar 2004
    Location
    India
    Posts
    2
    Perl,
    Thanks for your response. I am planning to do it on my test database and check the results. May be I will do it during this/next weekend.

    Prashanth.

  4. #4
    Join Date
    Nov 2002
    Posts
    207
    Also trying indexing on only one column, i.e. (i).

Posting Permissions

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