Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Location
    Kansas
    Posts
    5

    Exclamation Unanswered: Ver. 8 indexes and runstats on global temp tables

    By reading this forum, I now understand that you can create an index on a global temporary table in Version 8. Now I need to know how to runstat the global temporary table after I create the index and insert the data into it.
    Last edited by robbierob69; 07-14-04 at 19:12.

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow Something like this

    db2 => declare global temporary table session.t_test ( v_alder char (1))
    DB20000I The SQL command completed successfully.
    db2 => commit
    DB20000I The SQL command completed successfully.
    db2 => runstats on table session.t_test
    DB20000I The RUNSTATS command completed successfully.
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  3. #3
    Join Date
    Jul 2004
    Location
    Kansas
    Posts
    5
    thanks for your help, it is much appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •