- Enable storage of multiple values for a single column per row
- Number of multiple values are fixed by definition
- Limited to one column per table
- Array values are stored in the table itself (in line storage)
- Query performance likely to suffer
- Indexing a varray column is not possible
- Selection of array values is complex
- DML operations require use of constructor methods
- NULL values need to be specified explicitly
No comments:
Post a Comment