Skip to Main Content
Data Analytics & Visualization All-in-One For Dummies
book

Data Analytics & Visualization All-in-One For Dummies

by Jack A. Hyman, Luca Massaron, Paul McFedries, John Paul Mueller, Lillian Pierson, Jonathan Reichental, Joseph Schmuller, Alan R. Simon, Allen G. Taylor
April 2024
Beginner content levelBeginner
832 pages
20h 32m
English
For Dummies
Content preview from Data Analytics & Visualization All-in-One For Dummies

Chapter 5

Tuning Queries

IN THIS CHAPTER

Bullet Avoiding retrieving duplicate records

Bullet Managing multiple selection conditions

Bullet Saving resources with temporary tables

Bullet Filtering out groups that don’t meet a search condition

Bullet Working with indexes

Performance is almost always a top priority for any organizational database system. As the usage of the system goes up, if resources such as processor speed, cache memory, and hard disk storage do not go up proportionally, performance starts to suffer, and users start to complain. Clearly, one thing that a system administrator can do is increase the resources — install a faster processor, add more cache, buy more hard disks. These solutions may give the needed improvement and may even be necessary, but you should try a cheaper solution first: improving the efficiency of the queries that are loading down the system.

Generally, there are several different ways that you can obtain the information you want from a database; in other words, there are several ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Science For Dummies

Data Science For Dummies

Lillian Pierson
Data Science For Dummies, 2nd Edition

Data Science For Dummies, 2nd Edition

Lillian Pierson, Jake Porway

Publisher Resources

ISBN: 9781394244096Purchase Link