oracle對(duì)象定義(英文版)-文庫(kù)吧資料
2025-02-09 07:35本頁(yè)面
【正文】 799900002999Copyright 169。 2023 Global Business Solutions, Inc.Equipartitionsn Database objects have same logical partitionsn Examplesl Master and detail table l Table and indexOrder TableItem TableCustomer TableCustomer by State Copyright 169。 2023 Global Business Solutions, Inc.Advantages of Partitionsn Reduce time for data loads and index creationn Increase availability of missioncritical databasesn Create partition independencel Enable concurrent operations on separate partitionsl Execute queries on partitions instead of full table scanCopyright 169。Copyright 169。 2023 Global Business Solutions, Inc.Bitmap Indexn Bitmap created for each column valuen Common Usagel Very Large Tablesl LowCardinality Columnsn Featuresl Requires minimal storagel Improves performance‘F’BILLLISAANNTED1 00 10 11 0‘M’GENDERCopyright 169。 2023 Global Business Solutions, Inc.Index Typesn MultiColumnl Concatenated, positeIndex RowidOrderNo ItemNo Block.Seq.File006989 001 006989 002 OrderNo ItemNo Cust.007000 001 USA007000 002 GBSI007000 003 TEST007234 005 WEST 006989 001 ABC 006989 002 XYZORDER TABLECopyright 169。 2023 Global Business Solutions, Inc.Index Typesn Uniquel Duplicates not allowedn Nonuniquel Duplicates allowedXCopyright 169。 2023 Global Business Solutions, Inc.Temporary Tablesn Store session/ transaction specific datan Show data only to creating sessionn Discard data on mit or preserve data until session endsTablespace A Temp01 Temp02Copyright 169。 2023 Global Business Solutions, Inc.LOB Typesn CLOB stores character datan NCLOB stores doublebyte character datan BLOB stores binary data: graphics, video, soundn BFILE stores pointers to external filesExternal File SystemCustomersName … History Photo GreetingGee Copyright 169。 2023 Global Business Solutions, Inc.Table Datatypesn CHARn VARCHAR2n NUMBERn DATAn LOBCustomersName Address Phone…..Gee..123 Cherry 555 5555 Copyright 169。 2023 Global Business Solutions, Inc.Uses of Transportable Tablespacesn Archive OLTP and data warehouse systemsn Transfer data from OLTP to data warehouse staging systemsn Loading data marts from central data warehousesn Publish datan Move index data and avoid rebui
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1