Archives of the TeradataForum

Message Posted: Tue, 06 Dec 2005 @ 11:34:25 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I would think it is an ANSI SQL issue rather than just a teradata issue i.e. it pertains to more than one DBMS

In a performance specialist role it IS an annoyance in general to require accesses only in order to do explains because it may be difficult to get those authorizations on an operational production database.

Since performance is so critical to relational DBMS's then it is sensible that the performance role is supported by authorizations should exist such that explains can be done without any other authorization.

There is less exposure than with granting access to production operational system that is otherwise not required.

Being able to do explains in a dummy environment is just not good enough for performance analysis because you may get different access paths.

	<Prev	Next>		<<First	<Prev	Next>	Last>>