Re: UNIX-Box slow down while execute stored procedure

"Murray Wood \\(IList\\)" <ifxmaillist@quanta.co.nz> wrote in message news:<bn22qc$7b0$1@terabinaries.xmission.com>... > Start with ... > > When you run the procedure from dbaccess on the server how long does it > take? > Do you have the explain plan for the sqls in the procedure? (set explain on; > update statistics for your_procname;)> from dbaccess it is the same problem (run up to an hour and kills the unix-performance) the explain shows some sequential scans when the update(s) runs for all entries or when the where-clause goes over the temp table columns whitout an index. We have testet with some indexes (seq. scans replaces with index path) but nothing helps ... the session require too many - whatever