Re: Index with duplicate values

Mario Estrada wrote in message <6tveml$ao$1@news.xmission.com>... > >First of all, > >It is recommended not to have an index on a column with few different >values. OK. I'll buy that. But what do we do when we quick access based on the value in that column. This is a tracking application, and the column represents the status of the thing we are tracking. There are only a few of these values. However, I need to be able to read records for certain values in this column. This must be a common thing to do in tracking systems. > What type of locking do you have in that table? > We have row level locking.