I have a 14 million row table with one index on two fields one is a varchar
the other is a date. The combination of the two makes the row unique.
name date ... other fields
I have a table with just the names. each name occurs once.
I've tried a number of queries to find which name is in UName but not in
Data. However, they are all taking too long (more than 30 minutes - but
the hard drive is a slow 4200rpm IDE....).
What is the quickest query to get the result that I want? Also, should I
put another index on the Data table for "name" only?
pgsql-sql by date
|Next:||From: Alex Beamish||Date: 2004-12-09 20:19:56|
|Subject: parse error at or near "(" -- Huh???|
|Previous:||From: Matthew Engelbert||Date: 2004-12-08 19:21:45|
|Subject: Indexing Strategy|