Indexes Node
This section covers the following topics:
About Indexes
An index is a schema object that contains an entry for each value that appears in the indexed column(s) of the table or cluster. It provides direct, fast access to rows. Oracle Database supports several types of index:
-
Normal indexes. (By default, Oracle Database creates B-tree indexes.)
-
Bitmap indexes, which store rowids associated with a key value as a bitmap.
-
Partitioned indexes, which consist of partitions containing an entry for each value that appears in the indexed column(s) of the table.
-
Function-based indexes, which are based on expressions. They enable you to construct SQL statements that evaluate the value returned by an expression, which in turn may include built-in or user-defined functions.
-
Domain indexes, which are instances of an application-specific index of type indextype.
How the Indexes Node Works
There are two types of Indexes Node: One is a child of Data Connection Node and contains a set of all indexes in the database that are visible to the user. The other is a child of a Table Node and contains only those indexes that apply to the particular table. Each contains one or more child Index Nodes that represent indexes for a table schema object in the Oracle database.
To perform actions on the Indexes node: right-click the node and from the menu, choose the appropriate command. To view the node's properties, select the node and/or click Properties in the node's menu.
If this collection node is filtered, the icon changes to include a funnel symbol. For more information about filtering, see Filtering Collection Nodes.
See Also
Menu Options (child of Data Connection Node)
| Menu Option | Description |
|---|---|
|
New Index |
Creates a new Index using the Index Designer. |
|
Query Window |
Opens the Query Window so that you can execute SQL and PL/SQL queries from Visual Studio. |
|
Generate Create Script |
Writes the Index definitions to a If the object associated with the Indexes node is deleted from the database backend, this menu option does the following: Displays a message indicating that this object no longer exists in Oracle Database, and the script will not be generated. |
|
Generate Create Script to Project |
Generates the Index definitions to a . If multiple objects in Server Explorer are selected, a master SQL script is created in the Oracle Database Project Scripts folder. This master script contains calls to individual child SQL scripts (one for each schema object) generated into the various schema object folders and this master script is ordered with dependencies taken into consideration. If there are multiple open Oracle Database projects, Visual Studio prompts you to select the project to add the script to. This operation can also be performed by dragging and dropping the Server Explorer node(s) directly onto a database project folder. See Managing Oracle Script Files for more information. Note: Oracle Database Project Version 2 projects are not supported. To add scripts to this project type, use Import Schema or Add Existing Item menu items on an Oracle Database Project Version 2 project folder, or use the Schema Compare tool. |
|
Filters |
Opens the Filters Tab to control which child nodes appear under the collection. |
|
Privileges |
Opens the Grant/Revoke Privileges dialog box. |
|
Refresh |
Updates the Indexes node tree, including its associated Index nodes. |
|
Properties |
Displays the Properties window. |
See Also
Menu Options (child of Table Node)
| Menu Option | Description |
|---|---|
|
Design Table |
Creates a new index for the table using the Table Designer. This command is not supported for object tables. |
|
Refresh |
Updates the Indexes node tree, including its associated index nodes. |
|
Properties |
Displays the Properties window. |
See Also