[snazzybazzy]

also depends on your query pattern. Are you fetching many columns/rows or are you looking for one particular row? What do you mean by "large" as well. Are we talking GBs, TBs, or bigger?