If DBSPACETEMP not set:–explicit temporary table with create TEMP TABLE clause without “IN ” clause uses dbspace of current database. This action can severely affect I/O to that database, especially if it an I/O bound database.–creates in root db...
显示全部If DBSPACETEMP not set:
–explicit temporary table with create TEMP TABLE clause without “IN
” clause uses dbspace of current database. This action can severely affect I/O to that database, especially if it an I/O bound database.
–creates in root dbspace when explicit temporary table with the INTO TEMP option of the SELECT statement, can cause severe I/O to root dbsapce.收起