السلام عليكم ورحمه الله ,,

قبل ما اطرح السؤال عليكم .. قد قمت ببحث في المنتدي علي نفس السؤال وجت اجابه لكنها كانت صغيره نوعا ما

سؤالي هو : INDEX BY Table ؟
وفيم يستخدم ؟

وشكرا لجميع القائمين علي هذا المنتدي الرائع

هل تعني INDEX Organized TABLE - IOT

This is a table whose structure is like an index, meaning that the table itself is an index (it is already sorted). Other normal tables have their data stored in a Table Segment , then you can create indexes on certian columns, and Oracle will create another Index Segment by soring by the indexed columns. in IOT the table and the index are one and the same.
For other topic,, visit my website we you can find many Oracle tips

www.e-ammar.com

Ammar Sajdi
Oracle Consultant CEO
realsoft/palco
www.palco-me.com
www.realsoft-me.com

لا بد ان ياتينا عيد على شواطئ غزة
وتصهل فية ماذن القدس
ويشمخ البحر في يافا بالعيـــد وعوادة
وكل عام واتتم بخير

السلام عليكم
ساتم بشرح لك ما هو index by table
the index of table is consist of 2 things
1-primary key index of number and character
from this information we could know that is is unique from nuber and characters suchas 1,2,3 or a,b,c
there is another note that it is not sequencial so the number becaome 3,4,8,12,
2-second thing is the table which consist of similar datatypes
or values
each index is reffer to a cell in the table
and i think u know the syntax of who to create an index by table
و اتمنى ان يكون شرحي قد افاداك