سؤال في Dba

[malik alwadi]

السلام عليكم ورحمة الله وبركاته

بارك الله لي ولكم في هذا المنتدى الطيب
اخواني سؤالي ما المقصود CLUSTERوINDEX ? وماهي الوظيفة الرئيسية لهما؟

[ابن إنسان]

A cluster provides an optional method of storing table data. A cluster is made up of

a group of tables that share the same data blocks. The tables are grouped together
because they share common columns and are often used together.

Indexes are optional structures associated with tables and clusters that allow SQL

statements to execute more quickly against a table. Just as the index in this manual
helps you locate information faster than if there were no index, an Oracle index
provides a faster access path to table data

.

[جلال شواقفه]

اوجزت وأفدت شكرا