Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

data distribution on Oracle tables

Status
Not open for further replies.
karacharlie

karacharlie

Programmer
Dec 19, 2004
14
DE
How is a table on an Oracle system with many nodes stored? E.g. in Teradata a table is (hash) distributed by the choice of the primary index.
Has the choice of the index have an effect on join procedures, i.e. if two tables with the same index are joined via their index?
thanks
charlie
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
149
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
184
Andrzejek
Andrzejek
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
345
Andrzejek
Andrzejek
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
127
Andrzejek
Andrzejek
rk68
  • Locked
  • Question
inserting multi lingual data
Replies
0
Views
81
rk68
rk68

Part and Inventory Search

Sponsor

Back
Top