hi, guys:
several SQL statements, which are huge(join a lot tables and views) and a
lot of outer joins, those queries kill the CPUs(too many gets per
executions), since the guy who create those queries insisted that he has to
do that way(business logical required), and he said those queies was runing
just fine on sybase, is there any way that I can improve those SQL
statements performance and leave the SQL statement itself alone,
by the way, how come the sybase runing those queries is faster? thanks.
Received on Wed Jan 30 2002 - 21:45:38 CST
