• while select * , just try to trace the query and see how IO performs.

    try moving (copy) the table to another DB which is on another drive and check performance as well.

    is there any compatibility deffernce on the databases?

    is that all other table in the DB performing at this speed?

    Regards
    Durai Nagarajan