oracle對象定義(英文版)(編輯修改稿)
2025-02-23 07:35 本頁面
【文章內(nèi)容簡介】 lutions, 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.Balanced Index Tree (B*Tree)ROOTBRANCHROWIDPOINTERDATASEGMENT0000020234000000020232023249930003001400149995000700090005000599970007200810090009999ROWID|1/4” Rolled Sheet|100 Feet|5 Days|.LEAFCopyright 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.Function Based Indexn Create on functions or expressionsl User generated PL/SQLl SQL functions (nonaggregate)l External program (C callout)600500300250900660550330275990SALARY * FunctionBasedSingleSQL SELECT salary, salary* FROM employees。Copyright 169。 2023 Global Business Solutions, Inc.Partition Datan Depose tables and indexesn Each partition can be stored in different tablespaceCustomerCustNo CustName State…1 Kodak NY 4 Oracle CA 5 US Steel PA 6 Quest WA 7 Motorola TX Customers AL…INCustomers KS…NY Customers OH…WYCopyright 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。 2023 Global Business Solutions, Inc.Advantages of Partitionsn Control data storage across physical devicesn Maintain partition transparencyl Programs do not need to reference partitionsl Programs can take advantage of partitionsCopyright 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.Global Partitioned Indexesn Can impro
試題試卷相關推薦
鄂ICP備17016276號-1