Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    North Carolina
    Posts
    6

    Question how to index for different things?

    Say you have a table that looks like:

    lotsodata(client int not null, recorddate datetime, usefulgrouping varchar(20), datum1 int, datum2 int, datum3 char(10), datum4 int);

    Normally we search this table by: client, recorddate, usefulgrouping

    That would lead us to a logical clustered index of the same.

    For different reasons, we sometimes look up data like: client, recorddate, datum2

    What would be the best way to index for that situation? (running SQL2K if it makes a big difference)

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Take this question to the SQL Server forum. They can help you specifically with these indexing issues in SQL2K.

Posting Permissions

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