What is a scoped REF and when should I use it?
In general, a column may contain references to objects of a particular declared type regardless of the object table(s) in which the objects are stored. However, a REF type column may be scoped (constrained) to only contain references to objects from a specified object table. One should use scoped REFs whenever possible because scoped REFs are smaller in size than regular REFs on disk because the system does not have to store the table identifier with the scoped REFs. Also, queries containing navigation of scoped REFs can be optimized into joins when appropriate.
Related Questions
- Why is the error message "Code – 103, ref. 35054: NaviPlan cannot initialize its security sub-system" message being received after successfully installing the program?
- What is the difference between pass by reference(call by ref.) and pass by value(call by value)?
- What is a scoped REF and when should I use it?
