Member Avatar for anand01

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 ?

  • 2 Contributors
  • 2 Replies
  • 86 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by anand01
Member Avatar for smantscheff

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.

Member Avatar for anand01

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.