Hi Stefan, >From: Stefan Schmidt [mailto:[EMAIL PROTECTED] > >I am trying to add a column to an existing table in a database. When I >try to do this in SQL Studio, it give me a warning about "ALTER TABLE" >being very slow when used on a table containing data and then it seems >to hang. Is there a workaround for that? >
If you are adding columns of type LONG, the whole table has to be copied internally which can take some time depending on your table's size. If you want to add several columns of type LONG it is best to add them with a single SQL statement because then the table has to be copied just once. SQL Studio will be unresponsive until the operation has completed, so you have no choice but to wait and see. Best wishes, Martin SAP Labs, Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
