Subject: | |
From: | |
Reply To: | |
Date: | Wed, 16 Oct 1996 08:29:00 PDT |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
One minor clarification regarding IMAGE/SQL and Third Party Indexes:
Kumar wrote:
----------
>From: K N Kumar
>To: HP3000-L
>Subject: Re: Image/SQL
>Date: Wednesday, October 16, 1996 3:39PM
>
>Jim Keohane wrote:
[snip]
>> 3. There is no SQL (imbedded or API) that handles the special Image
>> datatypes (I3,J3,etc.).
[snip]
>When an Image DB is attached to a DBE, all TPIs are registered in the
>system catalog of the DBE if the DB is enabled for TPI. So Allbase knows
>about Image TPIs and will use them to optimize performance whenever
>appropriate.
*** Note: only some of the third party indexes are registered. There are 2
types: Sorted & Multiple and only the Sorted indexes are registered. And,
of these, only the keys on actual fields are indexed; composite (or
segmented) sorted keys are not.
Rich Trapp
[log in to unmask]
|
|
|