exp.test007.ksh

b树实现源码,linux和unix下运行,速度快,极好用

Case 1: -d option with no table
<Database Usage Statistics>
<DatabaseStatistics>
  <Database Name>  SYSTEMDB </Database Name>
  <Max Size> 1048576 </Max Size>
  <First Page> 17d84000 </First Page>
  <Total Pages> 109 </Total Pages>
  <Used Normal Pages> 11 </Used Normal Pages>
  <Used Merged Pages> 2 </Used Merged Pages>
  <Chunks Used> 13 </Chunks Used>
</DatabaseStatistics>
<ProcTable>
  <UsedSlots> 1 </UsedSlots>
  <FreeSlots> 99 </FreeSlots>
</ProcTable>
<TransactionTable>
  <UsedSlots> 0 </UsedSlots>
  <FreeSlots> 100 </FreeSlots>
  <UndoLogs>
    <TotalNodes> 0 </TotalNodes>
  </UndoLogs>
</TransactionTable>
<LockTable>
  <TotalBuckets> 2048  </TotalBuckets>
  <UsedBuckets> 0  </UsedBuckets>
  <TotalLockNodes> 0  </TotalLockNodes>
</LockTable>
<DatabaseStatistics>
  <Database Name>  userdb </Database Name>
  <Max Size> 10485760 </Max Size>
  <First Page> 17e7a000 </First Page>
  <Total Pages> 1279 </Total Pages>
  <Used Normal Pages> 0 </Used Normal Pages>
  <Used Merged Pages> 0 </Used Merged Pages>
  <Chunks Used> 0 </Chunks Used>
</DatabaseStatistics>
</Database Usage Statistics>
Tables and Indexes are created
Case 2: -d option with 1 table
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
Table created
Index created for f1
Table Dropped
<Database Usage Statistics>
<DatabaseStatistics>
  <Database Name>  SYSTEMDB </Database Name>
  <Max Size> 1048576 </Max Size>
  <First Page> 17d84000 </First Page>
  <Total Pages> 109 </Total Pages>
  <Used Normal Pages> 11 </Used Normal Pages>
  <Used Merged Pages> 2 </Used Merged Pages>
  <Chunks Used> 13 </Chunks Used>
</DatabaseStatistics>
<ProcTable>
  <UsedSlots> 1 </UsedSlots>
  <FreeSlots> 99 </FreeSlots>
</ProcTable>
<TransactionTable>
  <UsedSlots> 0 </UsedSlots>
  <FreeSlots> 100 </FreeSlots>
  <UndoLogs>
    <TotalNodes> 0 </TotalNodes>
  </UndoLogs>
</TransactionTable>
<LockTable>
  <TotalBuckets> 2048  </TotalBuckets>
  <UsedBuckets> 0  </UsedBuckets>
  <TotalLockNodes> 0  </TotalLockNodes>
</LockTable>
<DatabaseStatistics>
  <Database Name>  userdb </Database Name>
  <Max Size> 10485760 </Max Size>
  <First Page> 17e7a000 </First Page>
  <Total Pages> 1279 </Total Pages>
  <Used Normal Pages> 0 </Used Normal Pages>
  <Used Merged Pages> 0 </Used Merged Pages>
  <Chunks Used> 0 </Chunks Used>
</DatabaseStatistics>
</Database Usage Statistics>