On Fri, 4 Oct 2002, Becker, Holger wrote: >seems to me that the join transition isn't good enough, >i.e. you have to create some additional indexes on some >columns. >Every join transition should be the start of an index >or an primary key. >So if objectid is the only primary key column in your >tables you should create some indexes on TXobjectid >columns.
That's it. After creating index for the foreign keys as well, my 60-join query now runs in 10ms each. The 5-join one is done in 2ms. Whooaaa! Thanks, Holger. Agoston Horvath _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
