I've got two tables which have a lot of data in them (about 1,100,000). The deletion process takes about 15 minutes which is way too long. "DROP TABLE" is not an option for me so I was looking at alternatives. The "TRUNCATE TABLE" seems to be faster since it doesn't do any logging. However, I understand that I have to be in an "Oracle Mode" rather than "Internal Mode" for this sql statement to succeed.
My questions are: - What exactly is "Oracle Mode"? - How do I enter "Oracle Mode"? - I'm using JDBC. Do I to do anything specific with it? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
