I have a query I believe is not using the index...it's taking a long time to run. I haven't spent much time handling performance and tuning issues with solidDB, but did know "explain" is an option. I'm attempting to run an explain and it's causing solidDB to crash; maybe I'm doing something wrong.
> solsql "tcp 11100" id pw
> EXPLAIN PLAN FOR
SELECT COUNT(DISTINCT REFNO) AS COUNT
WHERE service_id = '0400'
AND date >= '2012-04-07'
AND date <= '2012-06-07';
Communication link failure
2012-06-20 11:25:01 IBM solidDB process has encountered an internal
error and is unable to
continue normally. Please report the following information to technical
Date: 2012-06-20 11:25:01
Product: IBM solidDB
....I've tried this on version 6.5 and version 7. Am I performing the explain correctly?