1. Perform a select
2. issue an explain command

odxsql> select * from table1

odxsql> explain

> explain
----------------------------------- SUMMARY -----------------------------------
Select        *
  from        TABLE1
  where       MYTEXT = 'bears';

Version:      5.1 Build 1A  (Compiled May  6 2010  21:06:44)
Optimization: MDKQUAL
----------------------------------- DETAILS -----------------------------------
Qualify (TABLE1)TABLE1 where MYTEXT = 'bears' on 1 with NOAUTORESET (Cached);
Fetchkeys $ROWID 1000 at a time on 1;
 Retrieve TABLE1 using $ROWID = $ODXID;
 Return TABLE1.MYSEQ, TABLE1.MYTEXT;
-------------------------------------------------------------------------------

For more detailed information and cpu timing statistics, issue the SET EXPLAIN COUNTS setting.

odxsql>  set explain counts 

Check the warnings check the retrieve

Any time see Retrieve, Omnidex had to read the data files.