Hire a PI to solve the mystery behind plan change

In this session, we’re setting up a coding crime lab to investigate plan change. Because running SQL statements with the right execution plan is crucial for database performance. But in some cases, due to various reasons, such as object changes and statistics changes, the database may pick the wrong execution plan. We’ll explore how Foglight Performance Investigator can simplify execution plan analysis and provide powerful clues that help DBAs and developers better understand execution plans.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish