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.
Here, we will look at some basic rules that need to be kept in mind when executing queries:
- Know your data: Understand the relationships between tables, know your data, and fetch only the required columns.
- Visualize the answer set: Don't just keep on pulling the handle till you hit the jackpot; always try to know the count of possible rows expected.
- Break...