Re: Query plan

[Tobias Downer <toby@xxxxxxxxx>]

Thomas Krogsæter wrote:

> Hi,
> another few plan question:
> is it possible to see, if an index is used during evaluation?

It's not always obvious from the plan if an index is used or not. 
However, if you see 'exhaustiveSelect' then this is always a table scan. 
  'patternSearch' is often a table scan also.  If you see 'simpleSelect' 
then index will be used if available.


> Is McKoi using pipelined evaluation?

Mckoi does not need to resolve the entire result at query time and does 
form a pipeline of the query result.  When the JDBC client fetches data 
from the result the pipeline structure is queried for the actual data 
which is the point at which the result set becomes opaque.  Did that 
answer your question?

Toby.