Via va Viaindex

[stewm@canada.com]

G'day,

I would never think to use Viaindex with relational tables simply because Cognos doesn't recommend it.  However I just seen a case where a fellow worker used Viaindex with RDB.  I attended the code review meeting for his enhancements and mentioned the fact that even the 'Qdesign' manual states that you shouldn't use Viaindex with relational linkages.  

What are the reasons why Via is the better choice with relational databases.  The manual only states that it is better because indexes may change and thus code changes are not needed or something like that.  This can't be the only reason because Cognos has recommended to some companies to remove all Viaindex occurrances through out their apps when relational tables are involved.  I've also heard that data retrieval results can be unpredictable with the database optimizer in conjuction with Viaindex.  Can someone tell me what ALL the drawbacks associated with using Viaindex with relational tables are?

Thanks in advance,

Mark Stewart
Consultants Club Corp.
Windsor, Ontario
Canada

Current Site:
7.10.G2 OpenVms
RDB
Bannockburn, Il

----------------------------------------------------------
Get your FREE personalized e-mail at http://www.canada.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.