表嵌套表和oracle中的varray之间的区别是什么,表嵌套表的varray或索引更好? [英] Difference between index by table nested table and varray in oracle and which is better varray or index by table nested table?

查看:79
本文介绍了表嵌套表和oracle中的varray之间的区别是什么,表嵌套表的varray或索引更好?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

假设您作为DBA在线企业工作。您必须处理大量数据并将其存储在数据库中。系统会要求您使用集合处理数据。集合的类型是按表,嵌套表和Varrays索引。通过考虑给定的场景,您会更喜欢哪种类型的存储,检索和灵活性?



我尝试过:



用坚实的推理来证明你的答案。

Suppose you are working in an online enterprise as a DBA. You have to deal with large amount of data and store it in database. You are asked to handle data by using collections. The types of collections are index by table, nested table and Varrays. By considering the given scenario, which type of collection you will prefer in terms of storage, retrieval and flexibility?

What I have tried:

Justify your answer with solid reasoning.

推荐答案

你无法实现'坚实的推理' Q& A

我建议你仔细研究这件事并做好自己的功课。
You cannot achieve 'solid reasoning' with Q&A.
I suggest you studying carefully the matter and doing yourself your own homework.


这篇关于表嵌套表和oracle中的varray之间的区别是什么,表嵌套表的varray或索引更好?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆