Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers

Why would you need to execute RUNSTATS regularly when using the SQL compiler?

Executing RUNSTATS updates the optimizer so it can compile the data properly.
Executing RUNSTATS optimizes the compiler so the updater can encode SQL statements sequentially.
Executing RUNSTATS optimizes the data in the right order so the compiler can send it to the optimizer.
Executing RUNSTATS provides the most current data which is used by the optimizer to create an effective access plan.
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon