|
|
Posted by John Bell on 09/03/06 20:50
Hi
I assume there is an index on this column (or a covering index on the ones
you are using)? Have you checked the query plan to see if other indexing is
needed, or have passed it through the index tuning wizard?
John
<rperetz@gmail.com> wrote in message
news:1157148982.155829.212030@p79g2000cwp.googlegroups.com...
> Hi all,
> I was given a task to create a houseHolding logic under a table that
> have millions records.
> first let me explain what is a house holding:
>
> let's say I have 2 records that have the same phone number, that mean
> that both records are under the same household, but this can get more
> complicated
> this article explain it
> http://www.teradata.com/t/page/115924/index.html
>
> if anyone worked with household he knows that you need to scan the
> table many time to get all the house holds, I used a dts to do it.
>
> I tested the dts on 11 records like the article did and that work
> great, but once I went to million records each loop is taking me 2 hour
> or so....a and I have no idea how how many loops I will have to do.
>
> if anyone out there worked with household queries and used sql, your
> imput would help me allot
>
> thanks.
>
Navigation:
[Reply to this message]
|