hi all,
I have doubt on Index,I know Index are used to increase the performance of table but my question is
where to create Index whether primary key table or foreign key tables ?
anand01
0
Junior Poster
Recommended Answers
Jump to PostIf you use the InnoDB engine with foreign keys, both primary and foreign key tables must have indexes on the common key field. Even with other engines indexes in all tables linked by foreign keys will boost performance.
All 2 Replies
smantscheff
265
Veteran Poster
If you use the InnoDB engine with foreign keys, both primary and foreign key tables must have indexes on the common key field. Even with other engines indexes in all tables linked by foreign keys will boost performance.
anand01
0
Junior Poster
thanks smantscheff
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.