Hi,
I have view which collect data from diffrients tables, and all these columns which is in this view are indexed at the orginal tables, my problem is when I run this view and this view return about 5000 rows, I cunt get all these rows at the same time, it return about 100 rows then the view take a break and then return more 100 and agien a break and then gives 100 rows. My quetion is dos any body know how get more than 100 rows at time ?

Thanks in advance

Hi,

Please, run select from view into temp xxx with no log, then select from temp table.

Gustavo.