Setup Preferences Help Logout

Database Instance: ablinux  >  Indexes  >  View Index: BALHAL.DEPT_PRIMARY_KEY

Logged in As SYSTEM

View Index: BALHAL.DEPT_PRIMARY_KEY

Actions Create LikeGenerate DDLManage Optimizer StatisticsRun Segment AdvisorReorganizeShrink SegmentShow Dependencies

	General
	Name DEPT_PRIMARY_KEY Schema BALHAL Tablespace USERS Index Type Normal Status VALID

	Indexed Table Object
	Index On Table Schema BALHAL Name DEPT

	Index Columns
	Column Name Data Type Sorting Order DEPTNO NUMBER ASC

	Partitions
	Previous   Next Partition Name Tablespace Status No partitions have been defined.

	Storage
	Tablespace Name USERS Extent Management Local Segment Management Automatic Logging Yes Space Usage Free Space (PCTFREE)(%) 10 Number of Transactions Initial 2 Maximum 255 Buffer Pool Buffer Pool DEFAULT

	Options
	Index Options UNIQUE

	Statistics
	Last Analyzed 2008-03-13 22:00:05 Blevel 0 Distinct Keys 4 Clustering Factor 1 Leaf Blocks 1 Average Leaf Blocks Per Key 1 Average Data Blocks Per Key 1 Number of Rows 4 Sample Size 4

	Actions Create LikeGenerate DDLManage Optimizer StatisticsRun Segment AdvisorReorganizeShrink SegmentShow Dependencies

Database

|

Setup

|

Preferences

|

Help

|

Logout

Copyright © 1996, 2005, Oracle. All rights reserved.

About Oracle Enterprise Manager 10g Database Control