Dumb Question regarding Indexes

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

.

Relevant Pages

  • Re: port forwarding
    ... > thx but it's really difficult to find exatly what i am looking for. ... Make your ASP.NET applications run faster ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ADO connection share
    ... thx, but I really mean several applications share the connection, not those ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Dumb Question regarding Indexes
    ... > I have noticed some applications create multiple indexes for a certain ... > Thx for any info. ... As I would like to say: "there are no dumb questions, ... Prev by Date: ...
    (comp.databases.oracle.server)
  • delete rows from datagrid
    ... My problem is that whatever rows I delete, dgDeleted is always empty ... What should I do to store the deleted rows in a dataset so i can ... Thx ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Not responding
    ... > any applications or to control panel etc. ... > "not responding". ... Prev by Date: ...
    (microsoft.public.windowsxp.basics)