|
|
Archives of the TeradataForum
Message Posted: Sat, 08 Nov 2003 @ 05:38:38 GMT
Subj: | | Re: Insufficient memory to parse request error |
|
From: | | Dennis Calkins |
On Thu, 6 Nov 2003 12:46:55 -0500, Claybourne Barrineau wrote:
| Can you easily determine the total numbe of tables (including those referenced by views) and case statements which make up your query
which is receiving the 'Insufficient Memory to Parse Request Error.' | |
There is a QUERY MODIFIER named
SHOW
It acts like
EXPLAIN
except that it SHOWS all the DDL of all the tables, views and what not that make up the query. ( provided you have the Access
Rights to see the underlying definitions )
| |