var t1 = DateTime.Now.Ticks;
  using (var cn = new CacheConnection("server=localhost;port=1972;namespace=TEST;uid=_system;pwd=SYS"))
  {
      using (var cmd = cn.CreateCommand())
      {
          cmd.CommandText = "select id from Class";
          var adapter = new CacheDataAdapter { SelectCommand = cmd };
          adapter.Fill(ds);
          dataGrid1.DataSource = ds;
          dataGrid1.DataMember = "Table";
      }
  }
  Text = new TimeSpan(DateTime.Now.Ticks - t1).Seconds + " s.";

План запроса:
SELECT %ID FROM Class WHERE Flag IN( 2 , 3 ) AND Param1= 10  ORDER BY Field


Относительная стоимость =  13366  
Call module B, which populates temp-file A.

Read temp-file A, looping on Field and a counter.

For each row:

 Output the row. 
 
module B 
Read bitmap index SQLUser.Class.iFlag, looping on Flag (with a given set of values) and ID.

For each row:

 Read master map SQLUser.Class.IDKEY, using the given idkey value. 
 Add a row to temp-file A, subscripted by Field and a counter, with node data of ID.

План запроса:
SELECT %ID FROM Class WHERE Flag IN ( 2 , 3 ) AND Param1->Value= 10 


Относительная стоимость =  13878  
Read bitmap index SQLUser.Class.iFlag, looping on Flag (with a given set of values) and ID.

For each row:

 Read master map SQLUser.Class.IDKEY, using the given idkey value. 
 Read bitmap index SQLUser.Param1.iValue, using the given Value and ID. 
 For each row: 
 Output the row. 

select Field from Class order by Field asc

Read index map SQLUser.Class.iField, looping on Field and ID.
For each row:
 Output the row.

select Field from Class order by Field desc

Read index map SQLUser.Class.iField, looping on Field and ID.
For each row:
 Output the row.

select * from Class where Param1= 10 

Относительная стоимость =  902840  
Read index map SQLUser.Class.iParam1, using the given Param1, and looping on ID.

For each row:

 Read master map SQLUser.Class.IDKEY, using the given idkey value. 
 Output the row. 

select * from Class where Param1= 10  order by Field desc

Относительная стоимость =  1153070 
Call module B, which populates temp-file A.

Read temp-file A, looping on Field and ID.

For each row:

 Output the row. 
 
module B 
Read index map SQLUser.Class.iParam1, using the given Param1, and looping on ID.

For each row:

 Read master map SQLUser.Class.IDKEY, using the given idkey value. 
 Add a row to temp-file A, subscripted by Field and ID, 
 with node data of Flag and Param1.