Hi Vince,Here is the information from the sdexinfo:
C:\mm>sdexinfo -o stats -f mmarea
------------------------------------------------------------------------
SDEX File: mmarea.000
Version: SDEX 10.0.0_1
Type: Final
Volume Type: Multi
Layer ID: 8
Description:
Database Name: sde
Table Owner: sde
Table Name: mmarea
Spatial Column Name: shape
Minimum Shape ID: 1
Spatial Index:
Parameter: SPIDX_RTREE
Array Form: -2,0,0
Entity Type: nac+
I/O Mode: NORMAL
Layer Config. Keyword: DEFAULTS
Layer Precision: High
User Privileges: SELECT, UPDATE, INSERT, DELETE
Creation Date: 04/07/12 22:08:09
Layer Envelope:
minx: 5513.00000, miny: 5099.38000
maxx: 655653.85000, maxy: 1220310.00000
XY False Origin: -5220400.0, -15524400.0
XY System Units: 10000.0
XY Half SysUnit: 0.00005
XY Round: 0.0001
XY Cluster Tolerance: 0.001
Z Offset: 0.0
Z Units: 1.0
Z Half SysUnit: 0.5
Z Round: 1.0
Z Cluster Tolerance: 0.001
Measure Offset: 0.0
Measure Units: 1.0
Measure Half SysUnit: 0.5
Measure Round: 1.0
Measure Cluster Tol: 0.001
Spatial Referencd ID: 2
Coordinate System: PROJCS["British_National_Grid",GEOGCS["GCS_OSGB_1936",DAT
UM["D_OSGB_1936",SPHEROID["Airy_1830",6377563.396,299.3249646]],PRIMEM["Greenwic
h",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PAR
AMETER["False_Easting",400000.0],PARAMETER["False_Northing",-100000.0],PARAMETER
["Central_Meridian",-2.0],PARAMETER["Scale_Factor",0.9996012717],PARAMETER["Lati
tude_Of_Origin",49.0],UNIT["Meter",1.0]]
SDE Attribute Columns: 16
Name Type Width numDecimal NULL? RowID
-------------------------------- ----------- ----- ---------- -------- -----
toid SE_STRING 20 0
version SE_INT32 10 0
verdate SE_DATE 0 0
featcode SE_INT32 10 0
theme SE_STRING 80 0
calcarea SE_FLOAT64 38 8
change SE_STRING 80 0
descgroup SE_STRING 150 0
descterm SE_STRING 150 0
make SE_STRING 20 0
physlevel SE_INT32 10 0
physpres SE_STRING 20 0
broken SE_INT16 5 0
loaddate SE_DATE 0 0
objectid SE_INT32 10 0 NOT NULL SDE
shape SE_SHAPE 0 0
Spatial Column Statistics:
Total Area Features: 106809759
------------------------------
Total Features: 106809759
Minimum Feature Number: 0
Maximum Feature Number: 0
Largest Feature: 41907 Points
Smallest Feature: 4 Points
Average Feature: 27.33 Points
Minimum Polygon Area: 0.00020 sq.
Maximum Polygon Area: 174317702.72110 sq.
Average Polygon Area: 2218.34133 sq.
Minimum Polygon Perimeter: 0.06472
Maximum Polygon Perimeter: 342097.43901
Average Polygon Perimeter: 138.52868
Layer Envelope:
minx: 5513.00000, miny: 5099.38000
maxx: 655653.85000, maxy: 1220310.00000
------------------------------------------------------------------------
Is the above what I should be expecting? I actually didnt know about SDEXinfo so thanks for teaching me something new.I will try the other command next.CheersDavid