[GENERAL] performance : index selection

2000-12-12 Thread Dmitriy Agafonov
elect count(*) from MyTable where IndexedField_i = value_i; (i = 1..n) Can I somehow let the Query Planner know about it ? I am pretty sure I can't do this with 7.0.2 , but what about 7.1 ?? Thanks a lot, Dmitriy Agafonov.

[GENERAL] cursor name : uniqueness scope

2000-11-06 Thread Dmitriy Agafonov
na change in 7.1, by the way?). I don't want to specify the cursor name explicitely every time I need to do a select. Instead I'm going to use a simple name generator. I just need to know what it is supposed to be associated with - a connection, client, database... Thank you, Dmitriy Agafonov.

[GENERAL] 7.1 release date ?

2000-10-27 Thread Dmitriy Agafonov
What's the release date for 7.1 ? Is it going to have support for the outer joins ? Are there going to be any performance improvements made (I'm particularly interested in data selection speed) ? Is it possible to obtain a list of new features which are coming with 7.1 ? I'm sure these question h