REQUESTS -TO STEP CACHE

Database
Enthusiast

REQUESTS -TO STEP CACHE

1)WHY RTS CACHE IS LRU BASED AND HOW?

2)WHY TERADATA COMPILES EXECUTABLE STEPS IF THE OPTIMIZER DETERMINES THA A LARGE NUMBER OF ROWS WILL BE RETURNED?