-Original Message-
From: Patrick FICHE [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2001 14:26
To: Robin Keech
Subject: RE: Slow Select count(*) - Second Post
Hi,
What do you think of creating a combined index containing fro example
soc_date, server_id, queue_id ) in this order
in WHERE clauses.
Patrick
-Message d'origine-
De : Robin Keech [mailto:[EMAIL PROTECTED]]
Envoy : mardi 20 fvrier 2001 16:15
: '[EMAIL PROTECTED]'
Objet : RE: Slow Select count(*) - Second Post
Thanks for your response,
What benefit would that give me? Would a combined index be faster? I
Thanks for your replies.
Patrick: I will try the combined index, and see if it takes too much disk
space. Most queries return within 2 seconds, which is acceptable for me.
Therefore I'm not too concerned about the speed increase in using a combined
index as such.
What I am concerned about
Thanks for all your help.
This has got the query time down to 5 seconds from 2 minutes!!
Much appreciated everyone.
Robin
-Original Message-
From: Tibor Simko [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2001 16:46
To: Robin Keech
Cc: '[EMAIL PROTECTED]'
Subject: Re: Slow Select count