79948

79948



Standard (B-tree) and Bitmap

A standard, B-tree index contains an entry for each value in the index key along with disk address of the row whcre the value is stored. A B-tree index is the default and most common type of indcx in an Oracle database.

A bitmap index uses strings of bits to encapsulate values and potcntial row addresses. It is morę compact than a B-tree index and can perform some types of retrieval morę efficiently. For generał use, however, a bitmap index requires morę overhead during row operations on the table and should be used primarily for data warehouse environments, as dcscribed in Oracle Database Data Warehousing Guide.



Wyszukiwarka

Podobne podstrony:
ZSBD 1 sysdatabases master Contains one row for each database on SQL Server sysusers Ali W Contains
File0026 D The busiest time for Monowi was in the 1930s. Then, the population was ISO, mostly farmer
POSTER SESSION. H25SITE SYMMETRY AND EFFECTIVE HAMILTONIANS FOR H2X MOLECULES IN THE LOCAL MODĘ LIMI
Milan Milan is a quite modern city, yet it includes mo numents of great artistic and historical valu
MR293R190?3 1 PREPARAT!ON AND PAISTING MKTHOD HO REPAIRS POSSIBLE Ali fittings to be painted in the
47267 MR293R190?3 1 PREPARAT!ON AND PAISTING MKTHOD HO REPAIRS POSSIBLE Ali fittings to be painted i
img450 (5) English for International Tourism In the hotel and tourism industries English language sk
and select as many values as they need. Then they should release the CTRL key, click right mouse but
34400 shoes&pattens5 115 Shoes in art and literaturę decorated shoes in the collection, except thos
34 Jacek lech there was a smali working in the form of a nichc with a dipping roof. Its maximum heig
image 19 Slider Category Slider Select post category, that contains posts you wish to show in the ho
APC 13 08 25 43 9 3d b) for an action which lasted for some time in the past and whose res
264 (42) 236 Dress Accessońes are fiat (no morę than 0.5mm thick) and are in the form of a disc with

więcej podobnych podstron