Page 1 of 1

sorting & partiotining

Posted: Fri Apr 18, 2008 9:02 am
by ajay.vaidyanathan
how much adviceable is it to perform a sort or a partioning before joining the records from sources. my record count is really high and its a production system i m dealing with.

Posted: Fri Apr 18, 2008 9:38 am
by samsuf2002
Sorting or partitioning are always recomended before you do a join but it all depend upon what type of join and what stage are you using for joining. And posting this topic in parallel forum will get good response.

Posted: Fri Apr 18, 2008 3:50 pm
by ray.wurlod
Moderator: please move to parallel forum