| # | Date | Forum | Type | Thread | Post |
|---|
| 7 | 14 Jun 2016 @ 03:44 PDT | Database | Topic | Spool in which volatile table lies. | Hi,
Is it possible to find the spool number in which volatile table lies?
Regards,
Chirag
|
| 6 | 14 Jun 2016 @ 03:40 PDT | Viewpoint | Reply | Negative Spool in Viewpoint | Hi Carlos,
Thanks for you answer.
But can you please update on what is Phantom / Orphan spool, Or do you have a link where I can read about it?
Regards,
Chirag
|
| 5 | 19 May 2016 @ 06:01 PDT | Viewpoint | Topic | Negative Spool in Viewpoint | Hi All,
Recently while monitering Viewpoint I saw one of the delete queries showing negative spool.
Can any one tell me what does that indicate.
Regards,
Chirag
|
| 4 | 02 May 2016 @ 01:18 PDT | Database | Reply | Avoid skewing during delete Teradata | Thanks for the Responce Todd.
Its a TYPO here the condition is tbl1.non-PI is not null.
Can you give me solution to solve the issue.
Regards,
Chirag
|
| 3 | 02 May 2016 @ 01:12 PDT | Database | Reply | system-determined change threshold for Stats-- Teradata | Thanks Dinesh
|
| 2 | 12 Apr 2016 @ 04:39 PDT | Database | Topic | Avoid skewing during delete Teradata | HI,
I am trying to delete the non PI column from the pi column of the same table.
Query as below.
delete From A tbl1
Where Exists(
&n... |
| 1 | 03 Mar 2016 @ 04:21 PST | Database | Topic | system-determined change threshold for Stats-- Teradata | Hi,
We are collecting stats on a table , however the stats collection is getting skipped.
On going for explain for the stats collect statement, we find something like:
We SKIP collecting STATIST... |
|
|