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.
Retrieve Disk Usage and Fragmentation Statistics
Use the -stats 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.
222 Chapter 17 • SPD Server Index Utility Ixutil
