First of all thanks for reply.

What is the size of some of these tables?

- some of tables are having 100 to 2000000 rows

How many pages?

- i don't know about pages. actually i don't know how to see it. where i can find it ?

Is there a Clustered Index on the tables in question?

- Yes, there are clustered indexes and non clustered too.