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