Re: Dumb Question regarding Indexes

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Fri, 29 Jul 2005 21:23:20 +0200
Message-ID: <42ea8229$0$14252$ba620e4c@news.skynet.be>

"Perm" <rhugga_at_yahoo.com> wrote in message news:1122653087.932424.29980_at_g47g2000cwa.googlegroups.com...
>I am a bit confused about creating indexes. If I have a table with 5
> columns, do I create an index for each column, or create an index for
> all columns in the same index, or what??
>
> I have noticed some applications create multiple indexes for a certain
> table, each containing 1 or more columns from the table, and some
> indexes contain the same columns as others...
>
> Thx for any info.
> BP
>

As I would like to say : "there are no dumb questions, only dumb answers" ;-) Received on Fri Jul 29 2005 - 14:23:20 CDT