How to clean / Purge DBQL Tables

delete from DBC.DBQLObjTbl Where CollectTimeStamp < '2009-10-01 00:00:00';
delete from DBC.DBQLogTbl where LogonDateTime < '2009-10-01 00:00:00';
delete from DBC.DBQLSqlTbl Where CollectTimeStamp < '2009-10-01 00:00:00';
delete from DBC.DBQLExplainTbl where CollectTimeStamp < '2009-10-01 00:00:00';
delete from DBC.DBQLStepTbl Where CollectTimeStamp < '2009-10-01 00:00:00';
delete from DBC.DBQLSummaryTbl where CollectTimeStamp < '2009-10-01 00:00:00';

Welcome to my teradata world !!

This is my first words in my new Teradata blog,

Actually i worked for a years as Teradata Database Administrator (DBA) and had a lot of experience, problem solving and tips and tricks in Teradata administration on going

I believe that we have to share our knowledge for all as the knowledge in increasing when your share it and decreasing when your keep it for your self

I will do my best to put all my knowledge on your hands.

and I hope that being useful for you

Mahmoud Karam, PMP, Teradata Certified Master