Check out example codes for "clear query cache sql server". It will help you in understanding the concepts better.
Code Example 1
DBCC FREEPROCCACHE DBCC DROPCLEANBUFFERS DBCC DROPCLEANBUFFERS clears clean (unmodified) pages from the buffer pool Precede that with a CHECKPOINT to flush any dirty pages to disk first DBCC FLUSHPROCINDB clears execution plans for that database
Learn ReactJs, React Native from akashmittal.com