Posted by Rich on 07/26/05 03:10

My table looks like this:
char(150) HTTP_REF,
char(250) HTTP_USER,
char(150) REMOTE_ADDR,
char(150) REMOTE_HOST,
char(150) URL,
smalldatetime TIME_STAMP

There are no indexes on this table and there are only 293,658 records total.

When I do a select like this it takes forever:

SELECT COUNT(DISTINCT REMOTE_ADDR)

Takes 2 minutes. Is there anyway to speed that up?

Thanks

• Next in forum: Re: Very slow distinct select
• Prev in forum: Re: Using CASE .. WHEN to have 'dynamic' sort
• Thread view: Very slow distinct select

[Reply to this message]