>I have a DBC into which I've loaded some 2X DBFs. Everything seems fine except for two things. I cannot seem to create a relation between any of the tables. Rushmore does not optimize more than one table in a SQL statement. I've used SYS(3054) to check the optimization level and one table is always optimized while the other is never optimized, not even partially. The SQL statements come directly from the 2X app which is being converted and much time was spent on optimizing them for Rushmore.
>
>Any ideas as to why the relation designer will not allow me to create
>a relation? Is it because they were imported and not created in the DBC? The keys I'm trying to link are named differently, but are identical in every other way. Both are tags in their respective CDX files. Any ideas as to why Rushmore will not optimize the second table in the query?
>
>Thanks,
>Steve Despres
>EZ Data Inc
>sdespres@erols.com
Thanks to Larry and Vladimir. I did find both answers yesterday but do appreciate your answers. The DB designer does indeed require at least one primary key defined for the parent table. As these were imported tables, none of them had one defined. As for the SQL statement, there is apparently been a change to the use of the IN and EXISTS keywords in a subSelect statement. Doing a swap of what was originally there solved that problem and the query now executes very quickly.
Steve Despres
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement