Determining Whether a Search Option Is Based on an Index or a Table

Before creating a search option, you need to determine whether to base it on an index and which one, or on a table and column and which ones. Table 3-1 can guide you in determining whether to use an index or a table. To determine which index or which table and column, you will need to do one of these tasks:

Open the mq_index view to see a list of indexes. The MARC map and table columns are part of each index definition. (Horizon displays this information in the Edit Horizon Index Definitions window. The MARC map for the index definition displays in the marc_map field and the table columns for the index definition display in the Base Index Col. and N_Keys Col. field.)
Run an SQL report to list all tables and columns.

Use the following sections to determine the index or table column needed to create the search option.

If you do not specify either an index or a table column for each search option you create, staff searching displays an error message.

 


© 1998-2017 Sirsi Corporation