Explorer Options
Go Up to Configuring Feature Options
The Explorer options are available on the following Options Editor tabs:
Explorer Options - Main Tab
The Options Editor’s Explorer tab controls the appearance and behavior of the Datasource Navigator/Explorer.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For related information, see Using the Datasource Navigator/Explorer.
Use the following table as a guide to modifying settings on this tab
| Setting | Description |
|---|---|
|
Refresh after Object Commands |
Refreshes the Explorer automatically after an object has been modified or created. |
|
Retain View Setting on Close |
Select to retain the current state of the Datasource Explorer so that it opens the same way on the next startup. |
|
Column filters use regular expressions by default |
Lets you use regular expressions when defining criteria for display of database objects in the right-hand pane of the Explorer. |
|
Display Explorer on startup |
Activates the Datasource Explorer on startup. For more information, see Using the Datasource Navigator/Explorer. |
|
Landing Page View |
Enables landing page views on a DBMS-by-DBMS basis. Landing pages display informative metadata that gives you a quick overview of your server/database. |
Explorer Options - Organization Tab
The Options Editor’s Explorer > Organization tab controls the appearance and behavior of the Datasource Navigator/Explorer.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For related information, see Using the Datasource Navigator/Explorer.
Use the following table as a guide to modifying settings on this tab
| Setting | Description |
|---|---|
|
Explorer organization |
Lets you select a default grouping option of Organize by Object Owner (groups objects, by object type, for each user) or Organize by Object Type (groups objects by object type for all users in the same list). Grouping by object owner is most efficient if you are working with databases containing a high number of objects. You can change the organization manually during a session. For details, see Basic Viewing Options in the Navigator/Explorer. |
|
Show System Objects and Show Only My Objects (available if you are organizing the Datasource Explorer by object type) |
Lets you select a default Datasource Explorer tree display options for system objects and objects that you own. Available options in the two groups are: Never - the relevant objects are not displayed by default. Always - the relevant objects are always displayed by default. Use datasource filter - The relevant default datasource filter is enabled. For more information, see Filtering in the Navigator/Explorer. You can change the Show System Objects and Show Only My Objects settings manually during a session. For details, see Basic Viewing Options in the Navigator/Explorer. |
Explorer Options - Limits Tab
The Options Editor’s Explorer > Limits tab controls the appearance and behavior of the Datasource Navigator/Explorer.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For related information, see Using the Datasource Navigator/Explorer.
While the DBMS is queried as necessary when you navigate the node hierarchy, it also caches nodes for the purpose of quickly repopulating if you move away from and then back to a node. For example if you open a Tables node and then an Indexes node and then again select the Tables node, the cached Tables sub-nodes are displayed.
The following setings are available
| Setting | Description |
|---|---|
|
Cache Expiration Time |
The duration a node is cached. Selecting a node after this expiration interval results in a fresh population. |
|
Maximum number of children to display per tree node |
Lets you place an upper limit of the number of nodes to display per node. |