You didn't mention which version of ClearQuest you are using.
It is true that you can't increase the page size beyond 100 in normal query view, but as of CQ 8.0.1 you can do a 'multirecord update'. This opens up a new UI on the query which allows you to view as many records as you want on one page.
To increase this beyond 100 rows, you have to be an administrator.
Go to site administration->configuration->application options.
Increase the size of the desired MRU page size here:
Maximum Multi-Record Update Page Size
Then users will be able to increase their MRU page size preference here:
Preferences->Multi-Record Update->Page size for Multi-Record Update:
Now, once you've logged off and back in again, run any query, right click and choose Multi Record Update. A new MRU tab will open up with the query in it. You'll see the page size is as you desired.
More information about multirecord update is here:
https://www.ibm.com/support/knowledgecenter/SSSH5A_8.0.1/com.ibm.rational.clearquest.user_web.doc/topics/t_perform_mru.htm