Order kit line creation throughput

You can calculate the Order Kit Line creation.

To calculate Kit Line creation, issue the following example:

   select substr(order_kit_line_key,1,10) time, 
          count(*) count
   from yfs_order_kit_line 
   where order_kit_line_key > '20110704000000' and
         order_kit_line_key < '20110704999999'
   group by substr(order_kit_line_key,1,10);
   

This query produces a listing like this:

   TIME                          COUNT 
   ------------------------ ----------
   2011070406                     3333
   2011070407                     3366
   2011070408                     3333