Re: View performance in IDS - suggestions?

Posted in 2005

david@smooth1.co.uk — 20 Dec 2005 13:34:14 -0800 — source: Usenet: comp.databases.informix

Which table is order_num in? There is an index on this column and the join column on the other table? You have done update statistics using Art Kagel's dostats? There are enough rows in both tables >1000 to warrant using an index?