which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?
Answer Posted / ankit gosain
Hi All,
Hash partitioning is more expensive than modulus but it'll
give better performance as well.
The basic difference is, you can apply Modulus partitioning
for the number fields only while you can apply Hash
partitioning for Varchar and any type of field.
If you have more queries, you can mail me on
ankitgosain@gmail.com
Cheers,
Ankit :)
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is aggtorec restructure operator?
What is the project in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is merge stage?
Differentiate between datastage and datastage tx?
What are routines in datastage? Enlist various types of routines.
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
project Steps,hits, Project level HArd things,Solved methods?
how do u catch bad rows from OCI stage? And what CLI stands for?
Difference between in process and inter process?
Define orabulk and bcp stages?
CHANGE CAPTURE
What are iconv and oconv?
How to manage date conversion in Datastage?