Select Record Identifiers

Perceptive Search must be able to uniquely identify each record returned by either one or more columns, generally the primary key. When working with a single table, it is usually sufficient to select one key. However, in complex SQL rules involving multiple tables, multiple keys are generally required.

You will be presented with a list of all columns from all selected tables, columns that have the key are known to be a primary key.

Performance

Perceptive Search may at any time request an SQL record using the key columns provided here. To obtain the best performance, it is recommended that you use columns that are primary keys or that are indexed.

If unsure, contact your database administrator.

Click Next to proceed to Title Column.