Select Tools | Administer | Index Fragmentation.
Note: You can also right-click an index from the Indexes node and select Defragment Index.
Select a database.
Tip: To narrow the search results enter a table or view name.
Click Search.
Note: You can set the scanning mode:
Select one or more indexes.
Notes:
Click .
Complete the fields as necessary. Review the following for additional information:
Fill factor setting |
Select one of the following options:
|
A stored procedure is reusable code that is stored on the database server and can be invoked by other applications. Currently, Toad supports T-SQL stored procedures.
Tip: You can change how objects display in the Object Explorer. For example, you can create custom categories or move objects out of existing categories (such as Programmability and Security) in Tools | Options | Explorer | Objects. See Object Options for more information.
You can display details about a procedure by selecting it in the Object Explorer. The following table describes the details associated with each stored procedure:
Use this tab... | To display... |
---|---|
Parameters |
Characteristics about the procedure such as position, name, data type, and length. |
Dependencies |
Dependent procedure objects and the objects that contain reference to the procedure. |
Extended Properties |
Extended properties you define to store additional metadata for this object. |
Script |
SQL statements for the selected object. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center