Question in statistics io result

• shamshudheen

  SSCrazy

  Points: 2390

  More actions

  April 23, 2008 at 6:49 am

  #128917

  i got the following result when i run my stored procedure

  Table 'syscomments'. Scan count 4132, logical reads 12930, physical reads 0, read-ahead reads 0.

  Table 'syscharsets'. Scan count 4132, logical reads 8531, physical reads 0, read-ahead reads 0.

  Table 'SK_AttrLookUp'. Scan count 1, logical reads 13, physical reads 0, read-ahead reads 0.

  Table 'spt_datatype_info'. Scan count 4532, logical reads 9064, physical reads 0, read-ahead reads 0.

  Table 'systypes'. Scan count 4532, logical reads 13596, physical reads 0, read-ahead reads 0.

  Table 'syscolumns'. Scan count 80, logical reads 471, physical reads 0, read-ahead reads 0.

  Table 'sysobjects'. Scan count 81, logical reads 469, physical reads 0, read-ahead reads 0.

  in the above result, i don't understand what is 'syscomments','syscharsets','spt_datatype_info','systypes' . since these tables are have more logical read counts

  any help is highly appreciated

  thanks in advance

• shamshudheen

  SSCrazy

  Points: 2390

  More actions

  April 23, 2008 at 7:07 am

  #806033

  sorry guys

  i found the result. since i am using INFORMAT_SCHEMA views i am getting these result

  Thanks