August 3, 2016

What is the use of CACHE ,NO CACHE in SQL


Below is some details or example what is the use of 'CACHE' ,'NO CACHE' option in sequence


1.Suppose cache is 10 so it will store the next 10 values in advance and that time it some issue happenes with database .we will lose that stored values

2.Values will be fetched from memory by pre-generating them to reduce I/O

3.Cache in sequence specifies that how many values will be stored in memory for faster access,It's default value is 20.