how to cache indexes in memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how to cache indexes in memory

  1. #1
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54
    Could someone please give the syntax or sample stmts to cache
    indexes of a table to memory. I already have the tables cached.

    Thanks in advance,

    Geo

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    CREATE [UNIQUE/BITMAP] INDEX schema.index_name
    ON schema.table(cloumn1, ...)
    STORAGE (BUFFER_POOL KEEP/RECYCLE);


    The things in [ ] are optional. / means either or.

    Hope this would help you,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

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



Click Here to Expand Forum to Full Width