Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: NOCACHE equivalent ?

    Oracle query :

    create table test(sno int, sno1 int) NOCACHE

    Is there any equivalent in SQL Server for the above (specifically for the NOCAHE syntax)

    Please advice,

    Thanks,
    Sam

  2. #2
    Join Date
    Oct 2004
    Posts
    2

    Arrow NOCAHE is default.

    NOCACHE is the default in SQLServer.

    More interesting would be the CACHE statement in a create.
    In SQLServer it is not possible directly afaik (correct me if I am wrong)
    You can however use DBCC PINTABLE(database_id, table_id)
    Look in the documentation for the use and working.

  3. #3
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up

    Hai..

    If u really want a table to be placed in cache then u can make the table as pintable so that in remains in the cache itslef. Surely this will increase the performance of that particular table provided the table is small in size. If the size of the table is more, then it will require so much memory, more over it will adversely affect the performace of other tables.

    So analyse ur requirement and if u really want to place the table in cache then u can use the syntax as specfied by Woosterom

    with regards
    Sudar

Posting Permissions

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