Dave,
It's best to keep threads on the list. On average, you'll get better and
faster responses when all the experts can see your question. Also, others
can benefit from the answers when they are on the list.
See my comments below.
Critters wrote:
Thanks for your response, here is some more de
Critters wrote:
Hi
I have a database with just over 10,000 records. with the following structure:
id, compid, name, score, and about 10 other fields
I have indexed id, compid, score
about 10 records out of the 10,000 have a compid of 2
when i do
select * from table where compid = 2
it was slow un
Hi
I have a database with just over 10,000 records. with the following structure:
id, compid, name, score, and about 10 other fields
I have indexed id, compid, score
about 10 records out of the 10,000 have a compid of 2
when i do
select * from table where compid = 2
it was slow until i indexed
