I have a question / concern regarding the D and I types:
If a D type is created (F1 below) and an I type added to the dictionary
referencing this D type directly (PRODUCT below), what is the impact on
indexing?
For example, if an index is created on the D type, will UNIBASIC code using
the I type benefit from this index?
The reason I am asking this, is that we have a system with all the data
tables created with D types called F1, F2, F3 etc, and all the coding is
using the I types for data access. The system has NO indexes created, and
even simple queries take ages to execute because of this...
I know from previous posts that it is not a good idea to create indexes on
fields that are TRANSed from other tables, but we can definitely benefit
from indexing on some of the more-used fields in our tables. My problem is
on which fields to create these indexes....
Type &
Field......... Field. Field........ Conversion.. Column......... Output
Depth &
Name.......... Number Definition... Code........ Heading........ Format
Assoc..
F1 D 1 Product Code 20L S
PRODUCT I F1 Product 20L S
Thanks & regards
Arnold Bosch
IT Administrator
Taeuber & Corssen SWA (Pty) Ltd
Email: [EMAIL PROTECTED]
>>Snipped...
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
