Introduction
While Teradata database has a reputation for lessening the work of a database administrator (DBA), one has to keep in mind that there are some issues which require an administrator's involvement. It could be any of the reason where direct involvement of admin is required. Some of the most frequently occurring issues are:
- Query performance
- System bottleneck
- Space management
- User management
The recipes in this chapter will primarily focus on resolving these issues; we will be using various tools for resolving issues related to user profiles, database space issues, and generating explain plans.
In this chapter, we will use recipes that will help us to create databases and users, and we will use various tools that will help to build a good and streamlined Teradata database system.