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!

different width of foregin key will affect the performance???

Status
Not open for further replies.
markco

markco

IS-IT--Management
Jan 8, 2001
25
HK
If a field in a table (eg. transactionno VARCHAR2(14)) which is foreign key of several tables, let say (table1: receiptno VARCHAR2(10), table2: creditnoteno VARCHAR2(14)...), then is it influence the performance when the linkage with transactionno AND the receiptno since the structure length is difference?
Thanks. Markco Wong
 
Sort by date Sort by votes
well, i dont understand why your structure is different, if you have a value with 14 chars in one table then 10 chars in another table you cannot refer to all the values from tha main table. its not meaning full to have it.
try to alter your tables and make it same on all the tables,
regarding performance. i think there wont be much difference, since both are same data type ô¿ô Kishore
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
398
Andrzejek
Andrzejek
torturedmind
  • Locked
  • Question
Week of the year
Replies
0
Views
88
torturedmind
torturedmind
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
183
Livia8
Livia8
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
195
Livia8
Livia8
kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
126
carp
carp

Part and Inventory Search

Sponsor

Back
Top