SAS Safety Scalable Performance Data Server 4.5 Manual De Usuario

   base=my_data.test
   data=my_data.test1;
run;

PROC SQL;
   delete from my_data.test
     where x=1;
quit;

The SAS program above creates a hybrid index for column X of the table named test, on
the machine named spot, in the directory named /spds.

Use the 

 option of ixutil to get the disk usage and segment list fragmentation

statistics for the index:

> ixutil -stats test -dsn test -libpath /spds

SAS Scalable Performance Data Server 4.5(TS M0) 
Build(Feb 26 2009, 11:50:08)
Index File Utility
Copyright (c) 1996-2009 by SAS Institute Inc, Cary NC 27513 USA

Statistics for Index X:
---------------------------------------------------
+--segment_size         = 8192
+--n_segments_in_tbl    = 5
+--n_values_in_index    = 2
+--n_vdeleted_values    = 1
+--percent_vdeleted     = 33.33
+--n_seglist_values     = 2
+--n_seglist_chunks     = 3
+--avg_chunks_per_list  = 1.00
+--idx_file_bytes       = 13304
+--idx_garbage_bytes    = 4272
+--percent_idx_garbage  = 32.11

Ixutil completed successfully

The statistics include the following:

•

The segment size of the index.

•

The number of segments in the table.

•

The number of distinct values for the index.

•

The number of virtually deleted values (values that are no longer recognized by query
indexes.)

•

The percentage of virtually deleted values.

•

The number of values that require segment lists (a value that is in only one segment
does not require a segment list).

•

The number of segment list chunks for all values of the index.