HP Intelligent Management Center Standard Software Platform - Manual (Page 662)

command provides a simple way to indicate the new name or location of
database files. In addition, the Set Datasource Location command
automatically converts your database driver to the data source you have
chosen. For example, you can automatically convert a direct access data
source to an ODBC data source using the Set Datasource Location command.
See "Changing the data source accessed by a report" in the online help.
Indexed tables
Creating indexes for database tables can increase the speed of data access
and reduce the time it takes for the program to evaluate data. Some DBMS
applications automatically index your database tables, while others require
that you create an index yourself. For the best report generation performance,
make sure each of your database tables has a corresponding index.
Note:
Some DBMS applications do not support indexed tables. Refer to the
documentation for your DBMS to find out if it supports indexes and how to
create them. If your DBMS documentation does not mention indexed tables,
it may not support them, and you should link tables based on common fields.
The Links tab of the Database Expert can also help you determine if your
tables include indexes.
Indexes organize the records in a relational database table so that data can
be located easier. For example, assume you have a table with the following
data:
Amount Customer Order#
25141.50 Allez Distribution 10444
19164.30 BG Mountain Inc. 10470
8233.50 Sierra Mountain 10485
24580.50 Mountain Toad 10488
662 Crystal Reports 2008 SP3 User's Guide
Understanding Databases 25
Databases overview