Statement Cache

IDS 9.40.FC8 Solaris 9 When I do onstat -g ssc I get lines as follows lru hash ref_cnt hits flag heap_ptr database user -------------------------------------------------------------------------------- 37 152 11 6549 DF 3c3d7e438......... 38 254 571 7302 -F 2e27fc038........ 24 133 66 7613 DF 3262e5038........ 47 230 232 7903 DF 3cbfbf438......... The SQL for the lines with "DF" have tables that have had update statistics run on them. My questions are: 1) Should I be concerned by this or just ignore it? 2) Will the queries return to state '-F', if so when? 3) Should I run onmode -e flush after update statistics? I've read and re-read the Performance Guide on SQL Statement Caching, is there any other information about this? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Windows Live' Messenger has arrived. Click here to download it for free! http://imagine-msn.com/messenger/launch80/?locale=en-gb