I am new to the MIMS world, and would like to know if MIMS is recommended to run with Oracle 8.1.6 in Rule or Cost optimization. We have quite a lot of direct SQL against the tables for external reporting. Right now we do not run ANALYZE or ESTIMATE STATISTICS on the tables or indexes, and wonder if it would help or destroy the MIMS environment (use of hints in the code?), and/or help the direct SQL queries.
Thank you for any assistance.
C.
Thank you for any assistance.
C.