1. To get statistics for a specific column:
runstate tablespace chid01r.qchssbat
table(dbuchir.qchtsbat) column(R_INVOICE)
sample 25;
2. To run agaist partition 2 of a TS and index:
runstate tablepsace chid01r.qchssbat
part 2
index( IX1 PART 2)
runstate tablespace chid01r.qchssbat
table(dbuchir.qchtsbat) column(R_INVOICE)
sample 25;
2. To run agaist partition 2 of a TS and index:
runstate tablepsace chid01r.qchssbat
part 2
index( IX1 PART 2)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/6126/viewspace-1776256/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/6126/viewspace-1776256/