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

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -