Toad Common shortcut keys

Source: Internet
Author: User

1, Toad How to carry out table analysis?
(1) Select the table name Press F4, and then pop up the dialog box has a button called Analyze table, click on the green triangle symbol
(2) The Role of table analysis is to organize the index, improve the efficiency of execution

2. How to view SQL execution plan in Toad
(1) through the Toad Run explain plan for the current statement or through the shortcut key ctrl+e see

3, Toad in common shortcut keys
F4 Look at the structure of the table
F5 execute the SQL in the dialog box, note that the end is required;
F7 clears all SQL in the current edit box
F8 View History of SQL statements
F9 Executing SQL for the current row
F10 See menu

Ctrl + F12 Save SQL as document
   Ctrl +. Complement the whole table_name
Ctrl + t complements full table_name, or displays fields
Ctrl + E to view the execution plan for the current SQL
Ctrl+enter directly executes the current SQL
ctrl+shift+f Formatting SQL statements
ALT + arrows look up and down SQL history
Ctrl+f Find
ctrl+r Replace to replace all you need to select entire scope in the dialog box
Ctrl+u all uppercase for the selected SQL statement
ctrl+l The SQL statement is selected all lowercase
ctrl+b will select the SQL statement statement Comment, Commet block
ctrl++shift+b will select the SQL statement to uncomment, Uncommet block


Toad Common shortcut keys

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.