Solving Daily Indexing Problems

Speaker: Uwe Ricken

Level: 300

Have you ever been in the situation that an application performed well the last day and – suddenly – you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happened this way in real life!

  • Why performance degradation in spite of maintenance jobs?
  • Just one more database in the result set and the query runs really bad – why?
  • Usage of literals is completely different from the usage of variables – why?
  • Identical data types but the query runs in part perfect and in part bad…
  • Your execution plan shows an INDEX SEEK – but the table will be scanned!
  • You get a query from the business which performs really badly but when you test it, it runs pretty cool – why?

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.