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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table vs Alias

Status
Not open for further replies.
stoggers

stoggers

Vendor
May 30, 2001
93
US
Hi,

What is the overhead of referring to an alias rather than an actual table?

What I am thinking of is a situation where there is one DB2 subsystem with two schemas each of which must contain an exact copy of the same refernce table.

Is it more efficient to create one copy of the table and an alias in the second schema or is it better to have two physical copies of the table?

Thanks,

Mike.
 
Status
Not open for further replies.

Similar threads

evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
201
evr72
evr72
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
220
fredericofonseca
fredericofonseca
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
179
pratimsingha
pratimsingha
usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
110
usr1234
usr1234
SE2097
  • Locked
  • Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
134
SE2097
SE2097

Part and Inventory Search

Sponsor

Back
Top