Get Started with Redwood: Oracle Cloud SCM and Purchasing
Data Models Best Practices
Summary
Are the Best Practices for Building Data Models using Tables vs. ViewsContent
Wondering if there are best practice guidelines for building Data Models?
For example, when pulling manager data, there are several tables with this information,
PER_ASSIGNMENT_SUPERVISORS_F
PER_ASSIGNMENT_SUPERVISORS_F_
PER_ASSIGNMENT_SUPERVISORS_F_V
What is the general rule we should be following? (reference the view, the table, etc)
Is there better performance using one over the other?
Tagged:
0