 Related Questions Latest Answer : An Index is based on tree structre that allow direct access to a row in a table, oracle uses different type of index 1) B-Tree Index2) Bitmap Index ... Latest Answer : We can update the index by rebuilding it.Alter index indexname rebuilt ... Latest Answer : The related columns of the tables in a cluster are called the cluster key. The cluster key is indexed so that rows of the cluster can be retrieved with a minimum amount of I/O. ... Latest Answer : An index cluster uses an index to maintain data within the cluster. The structure of a cluster index is similar to a normal index. Although a normal index does not store NULL key values, and index cluster can store it. And, a cluster index ... Latest Answer : A hash cluster uses a hash algorithm, which could either be system generated or user defined, to calculate the location of a row, both for retreival and for DML. ... Latest Answer : hash cluster --> preallocated based on number of keys and key size. index cluster --> not preallocated in both cases, you want to get the key size (amount of data associated with a given key) as good as possible, but with hash clusters ... Latest Answer : Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segment and a tablespace in which to create the index segment. ... Latest Answer : Index is an object in the oracle database used to speed up the performance of the queries ie. it improves the access speed and response of query will be good when the query makes use of Index.ThanksHarsha ... An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause Latest Answer : Indexes are used both to improve performence and to ensure uniquness of a column. Oracle automatically creates an index when a UNIQUE or PRIMARY key constarints clause is specified in a create table command.We can manually create our own indexes via the ... Group of tables physically stored together because they share common columns and are often used together is called Cluster. Latest Answer : Yes that is true, For creating cluster we first create the cluster via index/hash, then we all the tables in the cluster. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0