Working efficiently with data sources
This section will cover some basics of database tuning and ways to work efficiently with large data sources. Since the topic is more focused on data sources than on Tableau, no exercises are included.
Tuning data sources
If you are connecting to large data sources and are experiencing performance problems, a conversation with a Database Administrator (DBA) may be beneficial. Clear communication coupled with a small amount of database work could dramatically improve performance. The conversation should include database tuning points such as explicitly defining primary and foreign keys, defining columns as NOT NULL, and indexing. Each point will be discussed here.
Primary and foreign keys
Primary and foreign keys ...