Posted: 25 Jun 2015 10:21 EDT Last activity: 18 Jul 2017 10:45 EDT
Best practice to expose data tables?
Is it a good practice to expose data table so that if we apply any obj method on it , then instead of searching BLOB column of PR_OTHER , it will search at exposed column of a specific table.
I am populating value from a data table using dynamic select, should i expose it or not from performance point of view .
***Updated by moderator: Lochan to close post*** This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
It is more a matter of the use case. If the read are very infrequent, and can be cached in, let's say a data page, then maybe it's okay to leave it in the BLOB. That said, the number of records returned should be low as well.