What does NOCACHE do? | Tek-Tips

August 1, 2025

The NOCACHE option specifies that the blocks retrieved for the table are placed at the least recently used end of the LRU list in the buffer cache when a FULL table scan is performed. This will cause the blocks read with a full table scan to be immediately flushed from the buffer cache.

https://www.tek-tips.com/index.php?threads/what-does-nocache-do.707798/

What does NOCACHE do? | Tek-Tips <body> <h1> Array ( [0] => qhat does nocache do? | tek-tips [1] => ahat does nocache do? | tek-tips [2] => shat does nocache do? | tek-tips [3] => ehat does nocache do? | tek-tips [4] => 3hat does nocache do? | tek-tips [5] => 2hat does nocache do? | tek-tips [6] => wgat does nocache do? | tek-tips [7] => wbat does nocache do? | tek-tips [8] => wnat does nocache do? | tek-tips [9] => wjat does nocache do? | tek-tips [10] => wuat does nocache do? | tek-tips [11] => wyat does nocache do? | tek-tips [12] => whzt does nocache do? | tek-tips [13] => whst does nocache do? | tek-tips [14] => whwt does nocache do? | tek-tips [15] => whqt does nocache do? | tek-tips [16] => whar does nocache do? | tek-tips [17] => whaf does nocache do? | tek-tips [18] => whag does nocache do? | tek-tips [19] => whay does nocache do? | tek-tips [20] => wha6 does nocache do? | tek-tips [21] => wha5 does nocache do? | tek-tips [22] => what soes nocache do? | tek-tips [23] => what xoes nocache do? | tek-tips [24] => what coes nocache do? | tek-tips [25] => what foes nocache do? | tek-tips [26] => what roes nocache do? | tek-tips [27] => what eoes nocache do? | tek-tips [28] => what dies nocache do? | tek-tips [29] => what dkes nocache do? | tek-tips [30] => what dles nocache do? | tek-tips [31] => what dpes nocache do? | tek-tips [32] => what d0es nocache do? | tek-tips [33] => what d9es nocache do? | tek-tips [34] => what dows nocache do? | tek-tips [35] => what doss nocache do? | tek-tips [36] => what dods nocache do? | tek-tips [37] => what dors nocache do? | tek-tips [38] => what do4s nocache do? | tek-tips [39] => what do3s nocache do? | tek-tips [40] => what doea nocache do? | tek-tips [41] => what doez nocache do? | tek-tips [42] => what doex nocache do? | tek-tips [43] => what doed nocache do? | tek-tips [44] => what doee nocache do? | tek-tips [45] => what doew nocache do? | tek-tips [46] => what does bocache do? | tek-tips [47] => what does mocache do? | tek-tips [48] => what does jocache do? | tek-tips [49] => what does hocache do? | tek-tips [50] => what does nicache do? | tek-tips [51] => what does nkcache do? | tek-tips [52] => what does nlcache do? | tek-tips [53] => what does npcache do? | tek-tips [54] => what does n0cache do? | tek-tips [55] => what does n9cache do? | tek-tips [56] => what does noxache do? | tek-tips [57] => what does novache do? | tek-tips [58] => what does nofache do? | tek-tips [59] => what does nodache do? | tek-tips [60] => what does noczche do? | tek-tips [61] => what does nocsche do? | tek-tips [62] => what does nocwche do? | tek-tips [63] => what does nocqche do? | tek-tips [64] => what does nocaxhe do? | tek-tips [65] => what does nocavhe do? | tek-tips [66] => what does nocafhe do? | tek-tips [67] => what does nocadhe do? | tek-tips [68] => what does nocacge do? | tek-tips [69] => what does nocacbe do? | tek-tips [70] => what does nocacne do? | tek-tips [71] => what does nocacje do? | tek-tips [72] => what does nocacue do? | tek-tips [73] => what does nocacye do? | tek-tips [74] => what does nocachw do? | tek-tips [75] => what does nocachs do? | tek-tips [76] => what does nocachd do? | tek-tips [77] => what does nocachr do? | tek-tips [78] => what does nocach4 do? | tek-tips [79] => what does nocach3 do? | tek-tips [80] => what does nocache so? | tek-tips [81] => what does nocache xo? | tek-tips [82] => what does nocache co? | tek-tips [83] => what does nocache fo? | tek-tips [84] => what does nocache ro? | tek-tips [85] => what does nocache eo? | tek-tips [86] => what does nocache di? | tek-tips [87] => what does nocache dk? | tek-tips [88] => what does nocache dl? | tek-tips [89] => what does nocache dp? | tek-tips [90] => what does nocache d0? | tek-tips [91] => what does nocache d9? | tek-tips [92] => what does nocache do? | rek-tips [93] => what does nocache do? | fek-tips [94] => what does nocache do? | gek-tips [95] => what does nocache do? | yek-tips [96] => what does nocache do? | 6ek-tips [97] => what does nocache do? | 5ek-tips [98] => what does nocache do? | twk-tips [99] => what does nocache do? | tsk-tips [100] => what does nocache do? | tdk-tips [101] => what does nocache do? | trk-tips [102] => what does nocache do? | t4k-tips [103] => what does nocache do? | t3k-tips [104] => what does nocache do? | tej-tips [105] => what does nocache do? | tem-tips [106] => what does nocache do? | tel-tips [107] => what does nocache do? | teo-tips [108] => what does nocache do? | tei-tips [109] => what does nocache do? | tek0tips [110] => what does nocache do? | tekptips [111] => what does nocache do? | tek-rips [112] => what does nocache do? | tek-fips [113] => what does nocache do? | tek-gips [114] => what does nocache do? | tek-yips [115] => what does nocache do? | tek-6ips [116] => what does nocache do? | tek-5ips [117] => what does nocache do? | tek-tups [118] => what does nocache do? | tek-tjps [119] => what does nocache do? | tek-tkps [120] => what does nocache do? | tek-tops [121] => what does nocache do? | tek-t9ps [122] => what does nocache do? | tek-t8ps [123] => what does nocache do? | tek-tios [124] => what does nocache do? | tek-tils [125] => what does nocache do? | tek-ti-s [126] => what does nocache do? | tek-ti0s [127] => what does nocache do? | tek-tipa [128] => what does nocache do? | tek-tipz [129] => what does nocache do? | tek-tipx [130] => what does nocache do? | tek-tipd [131] => what does nocache do? | tek-tipe [132] => what does nocache do? | tek-tipw ) https://clipperroutesevere.com/kdjbw4ywu?key=a54852e5dee5f9fa314d768d692142d1 </h1> </body>