Fred >Does anyone know how big the first_rows buffer is? (If I use the hint, how >does Oracle determine how much data to bring back to me initially?) Mhmm... Do you mean the optimizer mode FIRST_ROWS? If yes, it's only an optimization goal, not the size of a buffer. If no, please, explain what do you mean... HTH Chris -- //www.freelists.org/webpage/oracle-l