VIAINDEX usage

[Deskin, Bob]

Peter is correct and so is your DBA. We take the VIAINDEX and break it down
to the associated columns. We also generate an ORDER BY. It's up to the
database to determine the best retrieval using those columns. So you can use
SORTED.

Bob Deskin              
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----Original Message-----
From: Peter Bateman [mailto:shediac92@hotmail.com]
Sent: Monday, February 17, 2003 7:22 AM
To: Roughsedge, Greg N; PowerhouseList
Subject: Re: VIAINDEX usage


Greg:

When using VIAINDEX PowerHouse I believe
sends an ORDER BY the segments of the index to
the database. So you should be able to use SORTED.

You can check this by using DBAUDIT=FULL
on your run of PowerHouse.

Regards,
Peter Bateman

----- Original Message -----
From: "Roughsedge, Greg N" <Greg.N.Roughsedge@team.telstra.com>
To: "PowerhouseList" <powerh-l@lists.swau.edu>
Sent: Monday, February 17, 2003 2:41 AM
Subject: VIAINDEX usage


> Hi,
>
> I would like some clarification around the use of the VIAINDEX clause.
>
> Background:
> Op Sys:        Open VMS V7.1-2
> Database:      Oracle RDB 7.0-6
> Powerhouse:  7.10.G1
>
> I've used the CHOOSE VIAINDEX <indexname> clause and then assumed that I
can use the SORTED clause as the records have been retrieved via the named
index.
> The DBA's believe there is no way to force the retrieval via a specified
index as the database will determine the most appropriate index and use this
regardless of what's specified.
>
> This equally relates to the LINK VIAINDEX clause as well as part of the
ACCESS statement.
>
> My question is, can I be absolutely guaranteed that the VIAINDEX option
will retrieve records using that index (and consequently know the sequence
of records retrieved). Or, should I not specify the VIAINDEX option and use
SORT instead of SORTED.
>
> Cheers
>
> Greg Roughsedge
> Media Solutions - Telstra
> (Black Diamond Technologies)
> (03) 8696 5968
>
>
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.