jstooge
VIP Member
Re: Customer Inquiry P4210 search
One suggestion...
Turn on the SQL Optimizer on the AS/400...run the problematic
search...the output generated will identify the indexes you need to
create. Create the indexes and regenerate the indexes, and you should be
good to go.
Jim
________________________________________________________________
Sign Up for Juno Platinum Internet Access Today
Only $9.95 per month!
Visit www.juno.com
One suggestion...
Turn on the SQL Optimizer on the AS/400...run the problematic
search...the output generated will identify the indexes you need to
create. Create the indexes and regenerate the indexes, and you should be
good to go.
Jim
________________________________________________________________
Sign Up for Juno Platinum Internet Access Today
Only $9.95 per month!
Visit www.juno.com