Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Fri, Mar 3 2006 12:34 PM	Permanent Link
"Halim Boumedjirek"	if I create two indexes, one based on [Column1] and the second is based on [Column1, Column2 ]; Do you think I will have the same perfomance (all the time) as if I had one index using [Column1, Column2 ] only? Do you think [column1] index is redondant in this case? -Halim
Mon, Mar 6 2006 11:51 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Halim, << if I create two indexes, one based on [Column1] and the second is based on [Column1, Column2 ]; Do you think I will have the same perfomance (all the time) as if I had one index using [Column1, Column2 ] only? Do you think [column1] index is redondant in this case? >> Yes, and yes. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Mar 6 2006 6:16 PM	Permanent Link
"Halim Boumedjirek"	Thank you, -Halim "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:5704BEFA-F7D7-4AD6-A2F0-E2A3EA8676D8@news.elevatesoft.com... > Halim, > > << if I create two indexes, one based on [Column1] and the second is > based on [Column1, Column2 ]; Do you think I will have the same > perfomance (all the time) as if I had one index using [Column1, Column2 ] > only? Do you think [column1] index is redondant in this case? >> > > Yes, and yes. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > >