Reviewing It

1:What would be the advantage of a partitioned index?
2:What is the advantage of an IOT over that of a HEAP Table?
3:Why does IOTs have the pseudo column 'ROWID'?
4:What is a b*tree level telling you?
5:Show the syntax to make a SQL statement use an existing index when a calculation on the indexed column is desired.
6:List some of the benefits and penalties of using bitmapped indexes.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.145.9.148