Spoil Table information in Data Dictionary

General
Enthusiast

Spoil Table information in Data Dictionary

What is the meaning of Spoil Table information in Data Dictionary . Will this affect performance?

Iam getting this while executing as one of the query in the explain plan --steps SPLTBL

4 REPLIES
Teradata Employee

Re: Spoil Table information in Data Dictionary

It doesn't have much impact on performance. It is the step to cleanup structure from DD.

Enthusiast

Re: Spoil Table information in Data Dictionary

Thanks Adeel.  But why it is trying to cleanup structure from DD?

Junior Contributor

Re: Spoil Table information in Data Dictionary

"We spoil the parser's dictionary cache for the table" removes all chached metadata about this table, e.g. after a ALTER TABLE or a CREATE INDEX, or after DELETE/UPDATE/INSERT of a larger number of rows.

This will also remove any cached execution plans.

Enthusiast

Re: Spoil Table information in Data Dictionary

Thanks Dieter.

Iam getting SPLTBL(Spoil Table information in Data Dictionary)  as one of the step(last step before End transaction) when Iam trying to insert into a table . This means it is trying to flush the metadata before ending the transaction?

This insert runs every 15 minutes since this is NRT( NEar real time) and we also delete the data from the table before inserting.

Once insert is completed we collect stats.

So this is the process

delete from table

insert into table

collect stats

the above process repeats every 15 min