Hi,
i am having a problem with indexing. In my database, one of my table have 3 foreign key references, All these fields are indexed by default. I need to create an index for a regular seach item. is there any problem regarding performance, if i combine the primary key and the field i mentioned above for indexing? Also if i am creating an index for a primary key separately will the performance degrade? MySql didnot show any error when i created an idex for a primary key.
But it showed a warning that there is an index for same field.
Please give me your suggestion regarding this
SubeeshBabu
0
Newbie Poster
Recommended Answers
Jump to PostYour primary key is already indexed by default. Creating a second index just wastes memory but should not decrease performance. If you want to know more on how MySQL handles indexes check out their documentation.
All 2 Replies
jbcrawford
0
Newbie Poster
Your primary key is already indexed by default. Creating a second index just wastes memory but should not decrease performance. If you want to know more on how MySQL handles indexes check out their documentation.
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
And for query optimization maybe look at multi-column indexes if you are passing more than one condition.
SubeeshBabu
0
Newbie Poster
Your primary key is already indexed by default. Creating a second index just wastes memory but should not decrease performance. If you want to know more on how MySQL handles indexes check out their documentation.
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
And for query optimization maybe look at multi-column indexes if you are passing more than one condition.
Thank you very much:icon_smile:
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.