sorting & partiotining

ajay.vaidyanathan · Post by **ajay.vaidyanathan** » Fri Apr 18, 2008 9:02 am

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.

samsuf2002 · Post by **samsuf2002** » Fri Apr 18, 2008 9:38 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 18, 2008 3:50 pm

Moderator: please move to parallel forum