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