dbvisualizer: number of rows limited by maxrows
Max rows is specified just above the SQL Commander tab in the second field from the right.   On the Object View tab it is at the bottom left of the results window.  For a single table query I generally use the Object View window.  It is easy to setup filters in the Data sub-tab. 

Setting this value too high will result in a crash when you run out of memory.  

Is there a reason you want more than 1000 records returned?  That's a lot of data to scroll through.