Advanced Indexing and Tuning for Large Databases

2-Day Webinar

This course shows a database administrator (DBA) or someone performing the DBA's function how to free up SQL in order to quickly find and resolve queries.  This allows search speeds to be improved drastically.  Students learn SQL best practices in order to ensure query optimization. 

Database Tuning is the activity of making a database application run more quickly.  This two-day course instructs administrators how to free up database systems from long-running queries and reports.  Index tuning are the steps one can take to reduce query processing time.  This is covered in the course as well.

Upcoming Classes

Course length: 2 days
Delivery: Online. 
Please call 475-328-2227 with questions.

Course Overview

Reading the Execution Plan

  • Learn to read this complex wealth of information and how to leverage the power of the SQL optimizer.

  • Keep and retrieve execution plans and dynamically choose the best ones for given data scenarios.

Designing Covering Indexes

  • Apply an indexing strategy to those “Problem” Queries and free up the system from long-running queries and reports.

  • Learn how to monitor IO and CPU utilization over time to improve the query performance.

Clustered Index Optimization 

  • Optimize the physical storage of data to match the usage and query pattern of your needs.  

  • Learn how to break-up the “junk-drawer” of files and free SQL to quickly find and resolve queries, improving search speeds drastically.

Partitioning Hot Spots

  • Learn how to partition data based on dates or other filters, limiting the physical IO necessary to resolve long running and complex queries.

  • Create a rolling partitioning scheme to constantly keep the needed data easily accessible.

ColumnStore Indexes

  • Learn how to use Column Storage of data to speed retrieval based on the cardinality of your data.

  • This technology is used in Oracle and DB2 and is now available in SQL server. 

In-Memory Optimization & Native Procedures

  • Learn how to utilize in-memory tables and SSD technologies to speed insertion and updating of data.

  • Create native compiled stored procedures to boost data insert times by 400%.