All Forums General
Purushotham 87 posts Joined 04/14
07 May 2014
difference between HASH INDEX and SINGLE TABLE JOIN INDEX

I have doubt on these topics.
 
what is the difference between single table join index and hash index ?
among these which is the good performance ?
 

Purushotham.M
Raja_KT 1246 posts Joined 07/09
08 May 2014

Documentation:
They are both created for goOd performance.
A hash index cannot have a partitioned primary index, but a single-table join index can.
A hash index must have a primary index, but a single-table join index can be created with
or without a primary index if it is column-partitioned.
A hash index cannot be column-partitioned, but a single-table join index can be column-partitioned.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Purushotham 87 posts Joined 04/14
09 May 2014

Hi Raja,
 
I understood that we cannot define secondary indexes, aggregate functions and triggers,PPI.
but  in single table join index can create aggregate functions(count(*),sum()), secondary indexes,PPI.
 
BUt i need ,among these which is the good performance,many people are asking this question.
Could u please explain ..
Thanks for your quick response Raja...
Regards,
Puru..

Purushotham.M

Purushotham 87 posts Joined 04/14
09 May 2014

Hi Everyone,
 
In multiload, why we need to specify work tables and why we dont specify work tables in fastload. what is the reason for work tables in multi load ?
could u please explain in detail.
Regards,
Puru.

Purushotham.M

Purushotham 87 posts Joined 04/14
09 May 2014

Hi Everyone,
 
could anyone explain performance tuning in detail steps, that would be helpful to me.
Hope you will give the response soon.
 
Regards,
Purushotham.

Purushotham.M

Raja_KT 1246 posts Joined 07/09
09 May 2014

STJI and HI , in terms of perfomance, are same.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Purushotham 87 posts Joined 04/14
09 May 2014

Thank u so much raja..
Regards,
Purushotham.
 
 

Purushotham.M

Purushotham 87 posts Joined 04/14
09 May 2014

Hi Everyone,
 
why we need to specify work tables in multiload, why we dont specify worktables in fastload ?
Can anyone tell me the reason...
 
 

Purushotham.M

dnoeth 4628 posts Joined 11/04
09 May 2014

Hi Purushotham,
please create a new topic for new questions.
You don't specify Worktables in FastLoad cause there are no Worktables in FastLoad :-)

Dieter

You must sign in to leave a comment.