Hi, Mike
They're just normal indexes. I experimented with clustered on either field a while back, and only got slightly faster response. The LName field is 15, and the ID is INT, 4. Each row is about 550 bytes.
Mark
>What type of indexes are on the lname and ID columns. You'll get much better performance out of a clustered index especially when your retrieving that much data.
>
>BTW, how large is one row? How large are the lname and ID column?
>
>-Mike
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.