Hi David,

> I'm not familiar with updating index stats. Is that feature
> available through ODBC... or do I need to use the services API?

As you're using 1.5 you can write a stored procedure to do it...

CREATE PROCEDURE SYS_RECALC_SELECTIVITY
AS
DECLARE VARIABLE INDEXNAME CHAR(31);
begin
for select rdb$index_name from rdb$indices into :indexname do
begin
execute statement 'set statistics index ' || :indexname;
end
end

This is the one I do. Run it occasionally as you see fit.

Regards
Ian Newby