📄 spacetable.out
字号:
0 rows inserted/updated/deletedij> drop table foo_longvarchar;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'FOO_LONGVARCHAR' because it does not exist.ij> create table foo_longvarchar (a long varchar);0 rows inserted/updated/deletedij> drop table foo_longvarbinary;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'FOO_LONGVARBINARY' because it does not exist.ij> create table foo_longvarbinary (a long varchar for bit data);0 rows inserted/updated/deletedij> -- Back to 4Kcall SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');0 rows inserted/updated/deletedij> drop table foo_bit;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'FOO_BIT' because it does not exist.ij> create table foo_bit (a CHAR(100) FOR BIT DATA) ;0 rows inserted/updated/deletedij> drop table foo_varbinary;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'FOO_VARBINARY' because it does not exist.ij> create table foo_varbinary (a VARCHAR(10000) FOR BIT DATA) ;0 rows inserted/updated/deletedij> select v.CONGLOMERATENAME, PAGESIZEfrom SYS.SYSSCHEMAS s,SYS.SYSTABLES t,new org.apache.derby.diag.SpaceTable(SCHEMANAME,TABLENAME) vwhere s.SCHEMAID = t.SCHEMAID and CONGLOMERATENAME in ('FOO_INT', 'FOO_VARCHAR', 'FOO_CHAR', 'FOO_LONGVARCHAR', 'FOO_VARBINARY', 'FOO_LONGVARBINARY', 'FOO_BIT') order by 1;CONGLOMERATENAME |PAGESIZE --------------------------------------------------------------------------------------------------------------------------------------------FOO_BIT |4096 FOO_CHAR |4096 FOO_INT |4096 FOO_LONGVARBINARY |32768 FOO_LONGVARCHAR |32768 FOO_VARBINARY |4096 FOO_VARCHAR |4096 ij> drop table foo_int;0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageReservedSpace','65');0 rows inserted/updated/deletedij> create table foo_int (a int);0 rows inserted/updated/deletedij> drop table foo_char;0 rows inserted/updated/deletedij> create table foo_char (a char(100));0 rows inserted/updated/deletedij> drop table foo_varchar;0 rows inserted/updated/deletedij> create table foo_varchar (a varchar(10000));0 rows inserted/updated/deletedij> -- let the foo_longxxx get created at 32Kcall SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', NULL);0 rows inserted/updated/deletedij> drop table foo_longvarchar;0 rows inserted/updated/deletedij> create table foo_longvarchar (a long varchar) ;0 rows inserted/updated/deletedij> drop table foo_longvarbinary;0 rows inserted/updated/deletedij> create table foo_longvarbinary (a long varchar for bit data) ;0 rows inserted/updated/deletedij> -- Back to 4Kcall SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');0 rows inserted/updated/deletedij> drop table foo_bit;0 rows inserted/updated/deletedij> create table foo_bit (a CHAR(100) FOR BIT DATA ) ;0 rows inserted/updated/deletedij> drop table foo_varbinary;0 rows inserted/updated/deletedij> create table foo_varbinary (a VARCHAR(10000) FOR BIT DATA) ;0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageReservedSpace',NULL);0 rows inserted/updated/deletedij> select v.CONGLOMERATENAME, PAGESIZEfrom SYS.SYSSCHEMAS s,SYS.SYSTABLES t,new org.apache.derby.diag.SpaceTable(SCHEMANAME,TABLENAME) vwhere s.SCHEMAID = t.SCHEMAID and CONGLOMERATENAME in ('FOO_INT', 'FOO_VARCHAR', 'FOO_CHAR', 'FOO_LONGVARCHAR', 'FOO_VARBINARY', 'FOO_LONGVARBINARY', 'FOO_BIT') order by 1;CONGLOMERATENAME |PAGESIZE --------------------------------------------------------------------------------------------------------------------------------------------FOO_BIT |4096 FOO_CHAR |4096 FOO_INT |4096 FOO_LONGVARBINARY |32768 FOO_LONGVARCHAR |32768 FOO_VARBINARY |4096 FOO_VARCHAR |4096 ij> -- 8K pagesize call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '8192');0 rows inserted/updated/deletedij> drop table foo_int;0 rows inserted/updated/deletedij> create table foo_int (a int);0 rows inserted/updated/deletedij> drop table foo_char;0 rows inserted/updated/deletedij> create table foo_char (a char(100));0 rows inserted/updated/deletedij> drop table foo_varchar;0 rows inserted/updated/deletedij> create table foo_varchar (a varchar(10000));0 rows inserted/updated/deletedij> drop table foo_longvarchar;0 rows inserted/updated/deletedij> create table foo_longvarchar (a long varchar);0 rows inserted/updated/deletedij> drop table foo_bit;0 rows inserted/updated/deletedij> create table foo_bit (a CHAR(100) FOR BIT DATA);0 rows inserted/updated/deletedij> drop table foo_varbinary;0 rows inserted/updated/deletedij> create table foo_varbinary (a varchar(10000) FOR BIT DATA);0 rows inserted/updated/deletedij> drop table foo_longvarbinary;0 rows inserted/updated/deletedij> create table foo_longvarbinary (a long varchar for bit data);0 rows inserted/updated/deletedij> select v.CONGLOMERATENAME, PAGESIZEfrom SYS.SYSSCHEMAS s,SYS.SYSTABLES t,new org.apache.derby.diag.SpaceTable(SCHEMANAME,TABLENAME) vwhere s.SCHEMAID = t.SCHEMAID and CONGLOMERATENAME in ('FOO_INT', 'FOO_VARCHAR', 'FOO_CHAR', 'FOO_LONGVARCHAR', 'FOO_VARBINARY', 'FOO_LONGVARBINARY', 'FOO_BIT') order by 1;CONGLOMERATENAME |PAGESIZE --------------------------------------------------------------------------------------------------------------------------------------------FOO_BIT |8192 FOO_CHAR |8192 FOO_INT |8192 FOO_LONGVARBINARY |8192 FOO_LONGVARCHAR |8192 FOO_VARBINARY |8192 FOO_VARCHAR |8192 ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');0 rows inserted/updated/deletedij> commit;ij> drop table foo_int;0 rows inserted/updated/deletedij> create table foo_int (a int);0 rows inserted/updated/deletedij> drop table foo_char;0 rows inserted/updated/deletedij> create table foo_char (a char(100)) ;0 rows inserted/updated/deletedij> drop table foo_varchar;0 rows inserted/updated/deletedij> create table foo_varchar (a varchar(10000));0 rows inserted/updated/deletedij> drop table foo_longvarchar;0 rows inserted/updated/deletedij> create table foo_longvarchar (a long varchar);0 rows inserted/updated/deletedij> drop table foo_bit;0 rows inserted/updated/deletedij> create table foo_bit (a CHAR(100) for bit data);0 rows inserted/updated/deletedij> drop table foo_varbinary;0 rows inserted/updated/deletedij> create table foo_varbinary (a varchar(10000) for bit data);0 rows inserted/updated/deletedij> drop table foo_longvarbinary;0 rows inserted/updated/deletedij> create table foo_longvarbinary (a long varchar for bit data);0 rows inserted/updated/deletedij> select v.CONGLOMERATENAME, PAGESIZEfrom SYS.SYSSCHEMAS s,SYS.SYSTABLES t,new org.apache.derby.diag.SpaceTable(SCHEMANAME,TABLENAME) vwhere s.SCHEMAID = t.SCHEMAID and CONGLOMERATENAME in ('FOO_INT', 'FOO_VARCHAR', 'FOO_CHAR', 'FOO_LONGVARCHAR', 'FOO_VARBINARY', 'FOO_LONGVARBINARY', 'FOO_BIT') order by 1;CONGLOMERATENAME |PAGESIZE --------------------------------------------------------------------------------------------------------------------------------------------FOO_BIT |4096 FOO_CHAR |4096 FOO_INT |4096 FOO_LONGVARBINARY |4096 FOO_LONGVARCHAR |4096 FOO_VARBINARY |4096 FOO_VARCHAR |4096 ij> commit;ij> disconnect;ij> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -