close
今天用Teradata連接資料時, 出現了下面的錯誤訊息, 查了一下網路後, 果然把SQL語法中的一小部分改掉就好.
no more spool space in Database - Stack Overflow
Spool space is a shared resource with limits placed upon users at the Profile or User level. Furthermore, spool space for a given user is shared across ALL active sessions.
Spool space problems occur either when you have an inefficient query or when statistics have not been properly collected on the tables you are using. It can also happen with tables where the primary index was poorly chosen (high skew). Spool is an attribute of the user account you are using to connect to the Teradata environment; it is not really an attribute of the database itself.If your query is inefficient, rewrite it. If statistics need to be collected or if the index needs to be altered, contact the DBA responsible for the tables you are using.
文章標籤
全站熱搜
留言列表
好物分享 (1)
{{ article.title }}
