>hi all,
>I have one table name app with 13000 records, primary key are "originid" char(2) and "appid" int
>
>when i fire a query select * from app. it will take 46 second. I laready have cluster index in the table.
>
>any idea how this query is too slow.
>
>thanks,
>...ashish
1) Are you using a where clause?
2) Try: from app (nolock)
You might post your sql here so I can examine it.
What is the table definition? Do you have any text datatype columns?