How a optimal query with "where clausule"

HCL Domino Domino Forum
1

I have a C++ Builder Application that use NotesSQL for API NOTES SERVER 5.XX access. I have read that a query with “where” clausule is ONLY OPTIMAL with a “equual-where”.

I need know how to make a OPTIMAL WHERE QUERY WITH A RANGE OF VALOURS, SO

SELECT * FROM MI_TABLE WHERE A<100 AND A>0

  Thanks !!!





     Nicolás.

P.D.: sorry for my bad english.