how to increase CPU usage?

[pemt]

Dear all,

I am running a query about comparing a million items in each of two tables.
It runs so low. And the CPU is only used for 13%. I wonder if there is any
way that I could speed up the running by increasing CPU usage.

Thanks,

pemt

 

[Jerry Whittle]

It probably isn't the CPU. Rather it's the disk access. So faster hard drives
might help.

However disk speed would be about the last thing that I'd check. Do you have
enough memory on the machine? Plenty of free hard drive space?

What does the SQL statement for the query look like? Are the fields in the
join indexed? Proper indexing would be the first thing that I'd check.

 

[pemt]

Thanks Jerry.

It probably isn't the CPU. Rather it's the disk access. So faster hard drives
might help.

However disk speed would be about the last thing that I'd check. Do you have
enough memory on the machine? Plenty of free hard drive space?

What does the SQL statement for the query look like? Are the fields in the
join indexed? Proper indexing would be the first thing that I'd check.