I have a fairly small table, approx 100,000 records. It has one ntext column, which has data ranging from 50k to 250k.

Doing a select for a fairly small number of records (using an index) that includes the ntext column, can take 30 seconds.

Help!

-Ken Williams