A Private Synonyms can be accessed only by the owner.
Public synonyms can be accessed by any user on the database.
Synonyms are used to : Mask the real name and owner of an object.Provide public access to an objectProvide location transparency for tables, views or program units of a remote database.Simplify the SQL
An Index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns
Indexes are automatically maintained and used by ORACLE. Changes to table data are automatically incorporated into all relevant indexes.
Latest Answer: Index is a Database object . It can be accessed rows physical fast. when you move the table from different table spaces or same table spaces indexes will unusually status. So You compulsory rebuild the index. Rebuilding the index is very fast than drop ...
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
Latest Answer: Clusters are groups of one or more tables physically stored together because they share common columns and are often used together. This improves disk access time.The related columns of the tables in a cluster are called the cluster key. The cluster key ...
The related columns of the tables in a cluster is called the Cluster Key.
A Cluster with an index on the Cluster Key.
A row is stored in a hash cluster based on the result of applying a hash function to the row's cluster key value. All rows with the same hash key value are stores together on disk.
Latest Answer: Hash Clusters cluster table data in a manner similar to normal, index clusters. To find or store a row in a hash cluster, Oracle applies a hash function to the row's cluster key value. The resulting hash value corresponds to a data block in the cluster.All ...
Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area
View page << Previous 2 3 4 5 [6] 7 8 Next >>
Go Top
