 |
 |
Archives of the TeradataForum
Message Posted: Mon, 17 Aug 2009 @ 21:37:18 GMT
| Subj: | | Re: Teradata Data Dictionary and DBQL |
| |
| From: | | Geoffrey Rommel |
| | But when I am thinking of 3rd party tools ... which are accessing the Data Dictionary even with the same user, I will definitely have a
less responsive access time compared to accessing a 'regular' database. | |
Ah, I see. The third-party tools tend to run a lot of data dictionary queries, sometimes several in a row, to make sure that the expected
tables exist. The data dictionary views contain a lot of joins -- for instance, to pick up database names rather than internal ID's -- so they can
take longer than you might expect. Some people have gone to the trouble of coding new dictionary-like views that do fewer joins so as to speed up
the process. In short, I suspect the long wait for dictionary queries has more to do with the views than with the user's priority.
| |
