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

Relational database basics................................................................658
Aliases ...............................................................................................659
Locating files......................................................................................661
Indexed tables....................................................................................662
Linking tables...........................................................................................665
Link from and link to...........................................................................665
Link relationships................................................................................665
Performance considerations in one-to-many links.............................666
Data file considerations......................................................................670
SQL database considerations............................................................673
Performance considerations for all reports........................................674
The Database Expert Links tab..........................................................676
Linking indexed tables........................................................................676
Link processing order.........................................................................677
Linking options...................................................................................678
Using SQL and SQL databases..............................................................696
What is SQL?.....................................................................................696
SQL DBMS.........................................................................................699
How does Crystal Reports use SQL? ...............................................700
The SQL language.............................................................................701
Server-side processing............................................................................704
How server-side grouping affects the SQL query..............................705
Mapping database fields..........................................................................707
About the Map Fields dialog box........................................................707
Remapping processes........................................................................708
Remapping altered database fields....................................................710
Saved Data Indexes................................................................................711
How Report Indexing works...............................................................712
Considerations for using Saved Data Indexes...................................713
Indexing the right field(s)....................................................................713
Unicode support in Crystal Reports.........................................................714
22 Crystal Reports 2008 SP3 User's Guide
Contents