 |
 |
Archives of the TeradataForum
Message Posted: Wed, 14 Nov 2007 @ 21:44:20 GMT
| Subj: | | Re: Cache in teradata? |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wed, 14 Nov 2007 16:38 -->
Bob Hahn wrote:
| | This is likely due to the operation of the Request Cache. There is good documentation of it's operation in the manual named "SQL
Reference: Statement and Transaction Processing", in Chapter 1 Statement Parsing. A short excerpt: | |
| | "The request cache stores successfully parsed SQL requests so they can be reused, thereby eliminating the need for reparsing the same
request parcel. | |
| | The cache is a PE buffer that stores the steps generated during the parsing of a DML request." | |
I agree that request cache can bring down the time required for execution but this should concern the time required for generating the plan of
action for the request alone. Do you think any plan creation would take morte then 5-10 secs at max?? I may be reading this wrong but that's how I
understand it.
Regards
| |
