F:\---\advise>db2advis -d test -a db2admin/ibmdb2 -s "select count(*) from nl where name between 'S' and 'T'" 
execution started at timestamp  2005 - 02 - 10 - 16 . 08 . 45 . 015000 
Recommending indexes...
total disk space needed for initial set [    0 , 009 ] MB
total disk space constrained to         [   11 , 812 ] MB
Trying variations of the solution set.
Optimization finished.
   1   indexes in current solution
 [  13 , 0000 ] timerons  (without recommendations)
 [   0 , 0482 ] timerons  (with current solution)
 [ 99 , 63 %] improvement


--
--
-- LIST OF RECOMMENDED INDEXES
-- ===========================
-- index[1],    0,009MB
   CREATE INDEX "DB2ADMIN"."IDX502101308460000" ON "DB2ADMIN"."NL" ("NAME" ASC) ALLOW REVERSE SCANS ;
   COMMIT WORK ;
   RUNSTATS ON TABLE "DB2ADMIN"."NL" FOR INDEX "DB2ADMIN"."IDX502101308460000" ;
   COMMIT WORK ;


--
--
-- RECOMMENDED EXISTING INDEXES
-- ============================


--
--
-- UNUSED EXISTING INDEXES
-- ============================
-- ===========================
--

 7  solutions were evaluated by the advisor
DB2 Workload Performance Advisor tool is finished.

F:\---\advise>db2advis -d test -a db2admin/ibmdb2 -i query.adv 
execution started at timestamp  2005 - 02 - 10 - 16 . 08 . 46 . 578002 
found [ 1 ] SQL statements from the input file
Recommending indexes...
total disk space needed for initial set [    0 , 009 ] MB
total disk space constrained to         [   11 , 812 ] MB
Trying variations of the solution set.
Optimization finished.
   1   indexes in current solution
 [  13 , 0000 ] timerons  (without recommendations)
 [   0 , 0482 ] timerons  (with current solution)
 [ 99 , 63 %] improvement


--
--
-- LIST OF RECOMMENDED INDEXES
-- ===========================
-- index[1],    0,009MB
   CREATE INDEX "DB2ADMIN"."IDX502101308490000" ON "DB2ADMIN"."NL" ("NAME" ASC) ALLOW REVERSE SCANS ;
   COMMIT WORK ;
   RUNSTATS ON TABLE "DB2ADMIN"."NL" FOR INDEX "DB2ADMIN"."IDX502101308490000" ;
   COMMIT WORK ;


--
--
-- RECOMMENDED EXISTING INDEXES
-- ============================


--
--
-- UNUSED EXISTING INDEXES
-- ============================
-- ===========================
--

 7  solutions were evaluated by the advisor
DB2 Workload Performance Advisor tool is finished.

F:\---\advise>db2level
DB21085I  Instance "DB2" uses "32" bits and DB2 code release "SQL08021" with 

level identifier "03020106".

Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", and FixPak 

"8".

Product is installed at "F:\SQLLIB".



F:\---\advise>db2licm -l 
Product Name                            = "DB2 Personal Edition"
Product Identifier                      = "DB2PE"
Version Information                     = "8.2"
Expiry Date                             = "Permanent"
Annotation                              = ""
Other information                       = ""