Options

The following are options you can set for DQL. Options are set with opt <option> <value>, and you can see the current option value with opt <option>

width	int / auto	Number of characters wide to format the display
pagesize	int / auto	Number of results to get per page for queries
display	less / stdout	The reader used to view query results
format	smart / column / expanded	Display format for query results
allow_select_scan	bool	If True, SELECT statement can perform table scans

Throttling

DQL also allows you to be careful how much throughput you consume with your queries. Use the throttle command to set persistent limits on all or some of your tables/indexes. Some examples:

# Set the total allowed throughput across all tables
> throttle 1000 100
# Set the default allowed throughput per-table/index
> throttle default 40% 20%
# Set the allowed throughput on a table
> throttle mytable 10 10
# Set the allowed throughput on a global index
> throttle mytable myindex 40 6

See help throttle for more details, and use unthrottle to remove a throttle. You can also set throttles on a per-query basis with the THROTTLE keyword.