doubledee Posted April 2, 2012 Share Posted April 2, 2012 What is the "name space" for Indexes in MySQL? Can I have an index name "idx_member_id" in both my MEMBER table and in my ANSWER table? Debbie Quote Link to comment Share on other sites More sharing options...
cpd Posted April 2, 2012 Share Posted April 2, 2012 Indexes are directly related to their tables. If you index something on one table, it wont index that field on another table, you will need to do it yourself. Quote Link to comment Share on other sites More sharing options...
doubledee Posted April 2, 2012 Author Share Posted April 2, 2012 Indexes are directly related to their tables. If you index something on one table, it wont index that field on another table, you will need to do it yourself. So if I have 20 tables, and every table has a field called "something", and on every table I create an Index called "idx_something" then there would never be a "collision" between Indexes?! Debbie Quote Link to comment Share on other sites More sharing options...
cpd Posted April 2, 2012 Share Posted April 2, 2012 Correct. Quote Link to comment Share on other sites More sharing options...
doubledee Posted April 2, 2012 Author Share Posted April 2, 2012 Correct. Okay, thanks! Debbie Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.