Re: Index to speed up "select count(*) from" queries...

From: <tim_mcconechy_at_my-dejanews.com>
Date: Tue, 18 May 1999 12:11:50 GMT
Message-ID: <7hrle7$4mo$1@nnrp1.deja.com>

Thanks that's perfect...
I never thought of it...
You just saved 16 seconds from my application startup! Much appreciated....

> SELECT COUNT(recno) FROM articolr
> WHERE recno > -999999 ;
>
> This may help. The WHERE clause should force the use of the index.
> The value should be out side of the valid range for recno. If it
> doesn't, then you could provide a hint in the SELECT to force the use
of
> the index.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 18 1999 - 07:11:50 CDT