|
|
Posted by Gert-Jan Strik on 05/30/06 19:21
If the table contains 1.5 millions rows, and the query runs for 16 days,
then there must be something wrong with the query or with the table
setup (inclusing indexes).
From your narrative I do not really understand what you are trying to
achieve. Please post DDL (including indexes), some sample data and the
results you are trying to achieve.
Gert-Jan
Tom Moreau wrote:
>
> 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]
|