plsql - Why are Oracle functions faster to return cached values than Views when queried from Tableau? -


i have oracle view has it's main sql decorated /*+ result cache */ , when query it, can see cached values returning fast in sqldbx, good.

but, when same select * done tableau, never seems use cached query! takes full time.

however when wrap view function, making function return view's data table, tableau gets data faster!

does make sense?


Comments