HP3000-L Archives

October 1997, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Jerry Fochtman <[log in to unmask]>
Reply To:
Jerry Fochtman <[log in to unmask]>
Date:
Mon, 6 Oct 1997 09:10:02 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (39 lines)
At 02:56 PM 10/6/97 +-200, Costas Anastassiades wrote:
>You also say that TPI's can dramatically improve access. So TPI's are
>recognized as indexes by IMAGE/SQL and can be used as such. Most
>interesting !

A number of issues regarding the SQL Optimizer's use of TPI indexes
have been resolved and will be in the version of IMAGE/SQL which is
shipping on Express 3. If you are considering utilizing TPI indexes
via SQL you need to move to this release of IMAGE/SQL as it resolves
a number of key issues to facilitate optimum use of TPI.

This same release of IMAGE/SQL also includes b-tree indexes.

<plug>

SUPERDEX users will need to be on version 4.1.44 or greater in order
to utilize TPI indexes and b-trees concurrently in the same database.

<end-plug>



/jf
                              _\\///_
                             (' o-o ')
___________________________ooOo_( )_OOoo____________________________________


 Yesterday (Sun.) in 1947 - President Truman made the 1st presidential
                            telecast address from the White House.
         This day in 1884 - The U.S. Naval War College was established
                            at Newport, R.I.

___________________________________Oooo_____________________________________
                            oooO  (    )
                           (    )  )  /
                            \  (   (_/
                             \_)

ATOM RSS1 RSS2