User Group August 13th Meeting - Lunch

Speaker: Brandon Leach. Topic: Building a proper indexing strategy.

Indexes play a crucial role in database performance. Proper indexes will significantly reduce query run times and reduce resource consumption. However if we do not take care when creating indexes we can actually hurt performance. To that end it is important to understand what makes for a good index as well as how to properly maintain indexes. In other words we need an indexing strategy.

In this session we will cover the following:

Heaps
Clustered vs non clustered indexes
How the optimizer determines what indexes to use – Statistics!
How to determine good indexes
How to implement proper index maintenance / Common strategies

Food: We still don't have a monthly sponsor, so please bring you own lunch. If you have any sponsorship ideas, please let me know.

Location: This will be our first meeting at the University of Oregon, Lokey Education Building. Parking on or near campus can be difficult, but free two-hour spots can usually be found in the neighborhoods between 15th and 18th Avenues, near Patterson and Hilyard Streets, a few blocks from the Lokey Education Building. LTD busses are another great way to get to campus.

Reminder to all: Please register as a member of PASS (http://sqlpass.org | it's FREE), and associate yourself with our chapter. It's how they keep track of our activity, and our size, which will help us when the SQLSaturday thing comes around.

Home Page: http://eugene.sqlpass.org/ Contact us via email at: eugene.oregon@sqlpass.org

We have a discussion board at http://groups.google.com/group/eugenesql?hl=en.

Ask your questions and hear from the community.

Also, like us on Facebook here: https://www.facebook.com/EugeneSQL/

Follow us on Twitter: @EugeneSQL or our LinkedIn Group: https://www.linkedin.com/groups/3681739