Re: query performance SE vs IDS

Hi, I agree with "Obnoxio" and I would add: a) Have you runned "update statistics" (high, medium ? ) b) Do you are talking about "select" tables, or "update", or "delete", or "load" ? c) Have you try using "directives" ?? Regards. H N Y (happy new year ) Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:<bsrpge$oh0m$1@ID-64669.news.uni-berlin.de>... > Jack wrote: > > > i'm looking for arguments to explain why several dbaccess on a single > > table are 2 times slower with ids than se. i understand this test > > isn't quite pertinant.The table is organize differently. > > The sqexplain shows an estimate cost equal to 1. i don't think so it > > could be less? Thanks for noticing this thread. > > a) What kind of machine, how much RAM, what disks, etc, etc. > 2) What do you mean by the table is organised differently? > iii) What SQL are you running? > D) What versions of SE and IDS?