Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Location
    India,Mumbai
    Posts
    34

    Questions on theory

    Hi Folks,
    Can you please help me to get the answers of below questions.
    1.What’s the asynchronus prefetch ? How it is helping in performance enhance?
    2.Apart from query plans, What else resides in proc cache ?

  2. #2
    Join Date
    Jan 2013
    Posts
    4
    ok, prep started

    1. It improves performance by anticipating the pages required for some db activities whose patterns are predictable as the IO request for these pages are issued before the query needs them so that most pages are in cache by the time query processing needs to access the page.

    More Info :http://manuals.sybase.com/onlinebook...TextView/43480

    Regards
    Shubham
    Last edited by shubham; 01-22-13 at 12:19.

Posting Permissions

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