JoinLinks property |
Applies to
TIB_Dataset
Declaration
Property JoinLinks : TIB_StringList;
Description
This property can play a very important role in th IB_Query component.
It is used to define join and filter criteria necessary for ensuring that
the columns in the KeyLinks property will accurately define each row of
the output uniquely.
This is so that the internal cursors that are used to fetch single record
buffers will be able to have simpler WHERE clause criteria and not be subject
to re-preparing every time the search criteria changes. It also makes it so
that the amount of input parameter data necessary to fetch the individual
rows is kept to an absolute minimum. Ideally, only key data should be used as
input parameter data for selecting individual rows. If the input parameters
used to define the entire dataset needed to be included for the fetching of
each individual record then performance would be severely degraded. This
property plays an important role in avoiding these degradations.