Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Words and Phrases
| Search for | Example | Results |
|---|---|---|
| A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
|
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Using Boolean Operators
| Search for | Operator | Example |
|---|---|---|
|
Two or more words in the same topic |
|
|
| Either word in a topic |
|
|
| Topics that do not contain a specific word or phrase |
|
|
| Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
| A combination of search types | ( ) parentheses |
|
- Data persistence
- Database dictionary
- Keys and indexes in Service Manager
- Data maps
- Exporting records
- Importing records
- Unload script utility
- Purging and archiving records
- Add, delete or update a master data record
- Database record auditing
- IR Expert
- Record retrieval
- Queries
- Database performance tuning
- Running the database maintenance utility
Keys and indexes in Service Manager
Service Manager keys are abstract entities that provide a logical view of the indexes in your RDBMS. When you create Service Manager logical keys, the server creates corresponding indexes on the back-end RDBMS. The benefits of using Service Manager logical keys are:
- They allow administrators a means to manage and move indexes from one environment to another (for example, from a test environment to a production environment)
- They allow administrators a means to move indexes from one RDBMS type to another (for example, from a SQL Server Express edition demonstration RDBMS to a supported RDBMS in a development environment)
In RDBMS terms, Service Manager keys provide constraints on column data as well as an index of the records in a table that improves query performance. From the Service Manager side, logical key definitions are one part of a database dictionary record. The full database dictionary record also includes field and column mappings. Typically, you will use database dictionary records to manage and move both logical keys and field mappings at the same time.
Currently, Service Manager can only push keys as indexes on an RDBMS. It cannot read existing indexes (pull) from the RDBMS and create the corresponding logical keys. Service Manager can still use existing indexes on an RDBMS without the indexes being defined as logical keys. Any query issued against an indexed column still gets a performance benefit. However you can only take advantage of the features of logical keys if you create them from Service Manager.
Service Manager uses the following logic to create indexes:
| Service Manager key type | Type of index created on the RDBMS |
|---|---|
| Primary | Primary |
| Unique | Index with unique constraint |
| No Nulls | Index |
| No Duplicates | Index |
| Nulls and Duplicates | Index |
| IR index | None Service Manager directly manages IR Index keys |
You can define Service Manager keys from either the System Definition utility or the Table Definition utility.
Related topics
Adding a key
Methods for adding database dictionary records
Add a key as the first key
Insert a key between other keys
Key type attributes
Key type definitions
