DBohner-(db)
Legendary Poster
Truncate Table \'function\'?
Is there a Truncate Table function?
We have several work tables that could / can get over half a billion records. When we go to clear Delete from them - it can take 30 minutes. If we could just execute 'Truncate Table'... it would take moments...
Also, is there a 'template' function that could be used to run Native SQL statements? I have a couple complex Mass-Insert/Grouped By Sum... queries - and I'd rather run them internally - than by executing an external script... If there is a function I could use as a template, passing a statement into - that would be grand!
(db)
Is there a Truncate Table function?
We have several work tables that could / can get over half a billion records. When we go to clear Delete from them - it can take 30 minutes. If we could just execute 'Truncate Table'... it would take moments...
Also, is there a 'template' function that could be used to run Native SQL statements? I have a couple complex Mass-Insert/Grouped By Sum... queries - and I'd rather run them internally - than by executing an external script... If there is a function I could use as a template, passing a statement into - that would be grand!
(db)