The Partitioning are found in the method of object (table or index) in parts (called partitions) on the basis of specific criteria as specified in the score distribution. The criteria can be a data set, the number of committees or other possible values. Suppose you have a large table, which makes is crazy, because it is very slow queries. You get so mad at the table, takes an ax and started in a logical partition table has many small cutting tables. Each table contains several columns, and stores no data. The so-called index of the table, where you can access - Oracle to complete the transaction as a single logical partition as a physical object. Oracle, you can arrange to share the following elements, tables, indexes, tables, indexes, materialized and materialized indices. Oracle does not support the separation of the groups or the clustered index. Why partition and indexes? Over time, some objects have a tendency to grow quickly, some are very large. This can lead to problems. A query takes longer to execute large partitioned tables. It takes more time to make a backup of the tables where the table. There is a need for more time to grow back on the table space table. The image is difficult to control. Object management issues such as storage parameters and fragmentation has become more complicated when the object is largest. It can be defined in different parts of the un-fragmented table to another table space. This could be for better performance and faster backup and recovery. Partitioning is an effective treatment method for these problems. This is a very effective strategy for some types of very large databases. Segregation is a great feature to keep Smart Security, for example, you can create a write-protected or disable the part of the table. The elements can be used as a basis for database decision support system DSS and data warehouses are typically used to process and store large amounts of data using complex queries. Items can also help VLDB involved in online transaction processing OLTP. These databases can store large amounts of data with high concurrent activities, and are relatively easy to treat small amounts of data requests. Oracle has introduced Oracle can take advantage of better separation of the eighth In Oracle8 simply divide the data into column values in the interval partition is called separation. Now Oracle has many other separation processes, which presented a list of partitions separate from the complex action. The division method is only available in Oracle Enterprise Edition, and not another version. Author is having 15+ years experience and providing Remote Oracle Support and Online Oracle Tutorials.
Related Articles -
oracle partitioning, table partition, table partitioning, index partition, index partitioning,
|