Performance of queries on sysmaster database

• The data is in shared memory but:

  • Views used by tables require disk access and may be slow
  • Complex views used to hid complex data
  • Some tables are large (250,000 locks)
  • Unbuffered logging of temp tables

Previous slide

Next slide

Back to first slide

View graphic version