Previous Topic

Next Topic

Book Contents

Book Index

Options - Display Limits

Max Rows Displayed

Specifies the number of rows to display when a query is run, or when a table is displayed. You may just wish to set this to the maximum value, however be very aware that when you set this to a large value your queries will take a long time to run and more memory will be used.

Our recommendation is to set this to a low value (1000) and just change this to a higher value when you want to see a lot of rows.

Warning: if you set this to No Limit, and display a very large number of rows, your machine can run out of memory. Use this with caution. For this reason, AQT will warn you if you use this setting.

If you are running the Evaluation version of AQT you will not be able to increase this beyond 50 rows.

Max Column Size

This option determines the maximum size of a column held in the result-set. Our recommendation is to set this to a low value (200) and change this to a higher value only when you wish to see the full text of your large columns. A high value will result in an large amount of memory used by AQT.

For displaying the full value of large columns (such as LOBs), it is recommended that you use Options > LOB Options > Write LOBs to Files.

If you are running the Evaluation version of AQT you will not be able to change the Max Column Size value.

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.