Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
table Indexes and performance |
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 > > |
This web page was last updated on Wednesday, May 15, 2024 at 08:40 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |