Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    61

    Unanswered: Rebuilding Index

    How can I rebuild one index for one table ?


    well, how I know what are the index of one table ?????

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    >>>> well, how I know what are the index of one table ?????
    answer:
    option 1) dbschema -d <you_database> -t <your_table> -ss
    option 2) open a connection with your database and write a SQL with tables "systables" and "sysindexes" or "sysindices"


    >>>> How can I rebuild one index for one table ?

    option 1) drop index...; create index...
    option 2) set indexes <idx_name> disabled; set indexes <idx_name> enabled
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Dec 2006
    Location
    Latrobe, PA
    Posts
    16
    Another option is:

    ALTER FRAGMENT ON INDEX <index_name>;

    If you want to place this in a new dbspace:

    ALTER FRAGMENT ON INDEX ixshipdeta2 <index_name> in <dbspace_name>;

Posting Permissions

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