oracle對象定義(英文版)-在線瀏覽
2025-03-09 07:35本頁面
【正文】 me Address... Photo Greeting Gee.. 123 Cherry Copyright 169。 2023 Global Business Solutions, Inc.External File SystemLOB Locatorsn LOB data stored separate from nonLOB data n BFILE data stored separate from databaseTablespace A TableName Add… * (Locators point to LOB and BFILE Locations)Tablespace B Copyright 169。 2023 Global Business Solutions, Inc.Customers Index Name 1 Acme Inc. 2 Zachary’s 3 Marie’s 4 Chimney Indexesn Optimize queriesl ROWID (Block.Row.File)n Stored independent of tablesn Consume minimal spacen Reduce I/On Index on WHERE clause columnsCustomers Table Name Addre..3 Marie’s 4456 Si 1 Acme Inc. 1236 Ch4 Chimney 9024 F 2 Zachary’s 1234 BrCopyright 169。 2023 Global Business Solutions, Inc.Index Typesn Single ColumnIndex RowidOrderNo Block.Seq.File007000 0000A .0004 .0003007000 0000A .0005 .0003OrderNo ItemNo Cust.006989 001 ABC 006989 002 XYZ006989 003 USA007000 001 USA007000 002 GBSI007000 003 TEST007000 004 XYZ007234 005 WESTORDER 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.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。 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 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.Global
試題試卷相關(guān)推薦
鄂ICP備17016276號-1