perfect! Thanks! On Feb 1, 2010, at 5:26 PM, Knut Anders Hatlen wrote:
> David Parker <[email protected]> writes: > >> I am trying to address some insert performance issues we are having >> for a wide table by increasing the pagesize for that table. As far as >> I can tell, this means issuing a call to syscs_set_database_property >> to set the desired pagesize, then creating the table. I'd kind of like >> to be able to verify that the table created has the proper pagesize. >> >> Is there a way to determine the pagesize being used by a given table? > > You can use the SYSCS_DIAG.SPACE_TABLE table function: > http://db.apache.org/derby/docs/10.5/ref/rrefsyscsdiagtables.html > > For example, if you want to verify the page size of the table MYTABLE in > schema MYSCHEMA, execute the following statement: > > ij> select pagesize from table (syscs_diag.space_table('MYSCHEMA', > 'MYTABLE')) s; > PAGESIZE > ----------- > 4096 > > 1 row selected > > Hope this helps, > > -- > Knut Anders ============================================= David Parker [email protected]
