Modify a query

You can quickly modify queries to experiment with subqueries or select and execute only portions of a query.

1. To run all or part of a query, use the following shortcuts:

   • Ctrl+M: Selects the command at the current cursor position.

   • Ctrl+R: Selects and executes the command at the current cursor position.

2. To comment a line so that it does not execute when the query is run, place the cursor anywhere in the line and press Ctrl+-.

   The line is made into a comment by inserting "--" at the beginning. To un-comment a line place the cursor anywhere in the line and press Ctrl+-.

   You can also right-click on the line you want to comment or uncomment and select Comment/Uncomment.

3. You can specify how long a query should run before timing out. Right-click anywhere in the query and select Command Timeout > timeout_period.

   The default timeout period is 60 seconds, which means that the query is halted if it has not completed within 60 seconds. Setting the timeout period to 0 seconds eliminates the timeout period, permitting your queries to run to completion regardless of how long it takes. You can also select pre-defined time periods of 30 seconds, 1, 2, 5, or 10 minutes, or select Custom to specify any number of seconds for the timeout period.