#DateForumTypeThreadPost
507 Feb 2007 @ 11:56 PSTDatabaseReplywants to delete rows older than 2 rows in a colomnI would take the previous advice of first running this as a SELECT as follows:SELECT * FROM tab_aWHERE col_a < DATE - 730;perhaps we should take year of 366 days into considerationand first select ...
407 Feb 2007 @ 11:50 PSTDatabaseReplyReducing colum lengthperhaps create insert is better,
306 Sep 2006 @ 02:56 PDTToolsReplyFastload-ing the FastExported Data.???you may fexp the result as fixed-length files ,so you may fastload quickly or you may fexp the result file as fixed-seperator.for example you may fexp as fixed-length select cast( a as char(10))|| ...
228 Aug 2006 @ 11:27 PDTToolsReplySecondary index Subtableyou may see it in dbc.tables
128 Aug 2006 @ 11:00 PDTToolsReplySQL Qery Performance Problemwell ,you may list the excute plan first :-)

Pages