Have you been struggling with your queries running for a long time, have your queries been flagged on more than one occasion, or have you been reprimanded by your DBAs multiple times regarding high system resource consumption? Are these some situations you have been through? If yes, the queries you are running are not efficient and need to be looked at for performance improvement/optimization.
There are three types of typical users that use Teradata database:
- Business users
- Developers
- Administrators
The administrator community obviously wants the queries running on the Teradata system to be as efficient as possible.