Archives of the TeradataForum
Message Posted: Mon, 24 Oct 2005 @ 13:11:41 GMT
Subj: | | Re: Help on Join Index with Outer Joins, please. |
|
From: | | Simard Rudel |
We experimented and the way we implemented Join Index is tricky. Specially to be sure than a BI product, with generic SQL, can use Join
Index.
We create the Join Index.
We create a view with the same SQL than je Join Index.
We use this 'join idex view' and join it with other view.
Rudel Simard
Service de l'administration des donnes
Regie de l'assurance maladie du Quebec
|