|
|
Posted by Tom Moreau on 05/30/06 18:07
Moving it to Oracle won't buy you anything. Perhaps indexing on each of the
columns to be filtered will help you.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"groupy" <liav.ezer@gmail.com> wrote in message
news:1149010763.810314.63670@i40g2000cwc.googlegroups.com...
input: 1.5 million records table consisting users with 4 nvchar
fields:A,B,C,D
the problem: there are many records with dublicates A's or duplicates
B's or duplicates A+B's or duplicates B+C+D's & so on. Mathematicly
there are 16-1 posibilities for each duplication.
aim: find the duplicates & filter them, leave only the unique users
which don't have ANY duplication.
We can do it by a simple select query that logicly checks the
duplication in a OR operator.
But it takes about 16 days in a very fast PC.
The DB is in sql-server, converting it to Oracle might acomplish it to
8 days.
How can i do it in a few hours?
Remeber that filtering first the users with parameter A & than by
parameter B & so on will result an error in the final result because it
will loose the information regarding the filtered users - maybe in
parameter C they are equal to other users in the table...
THANK YOU
Navigation:
[Reply to this message]
|