Hello:

Just curious to know, if Select statement with full tablescan (No indexes are used or not existing based on CBO) uses db_buffer_cache?

If the table is indexed and if server process using indexes to fetch data then, definitely it has to use db_buffer_cache? Isnt it?

Thanks, ST2003