Are indexes auto created when you create a foreign key?
This is a discussion on Are indexes auto created when you create a foreign key? within the MySQL Database forums, part of the Database Forums category; When you create a foreign key, is an index also created for the same column? I have searched around for ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-21-2008
|
|||
|
|||
Are indexes auto created when you create a foreign key?
When you create a foreign key, is an index also created for the same
column? I have searched around for the answer on this and I have gotten conflicting answers. They way mysql works, is this the same for all databases? Thanks for the help. 
|
|
04-21-2008
|
|||
|
|||
|
Re: Are indexes auto created when you create a foreign key?
On Mon, 21 Apr 2008 09:05:23 -0700 (PDT), chris wrote:
> When you create a foreign key, is an index also created for the same > column? I have searched around for the answer on this and I have > gotten conflicting answers. Depends on the version. In Mysql version 4.1.2 and later, the InnoDB engine will build the index automatically. Prior versions needed the index to be created beforehand, and then specified when you're actually declaring the FK. > They way mysql works, is this the same for all databases? Yes, the same for all databases, because this is version-dependant behavior. -- I think I'd like to see a Simpsons episode starting up with Bart Simpson writing "I will not attempt to undermine the Usenet Cabal". -- J. D. Falk
|
|
04-21-2008
|
|||
|
|||
|
Re: Are indexes auto created when you create a foreign key?
On Apr 21, 10:49*am, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> On Mon, 21 Apr 2008 09:05:23 -0700 (PDT), chris wrote: > > When you create a foreign key, is an index also created for the same > > column? *I have searched around for the answer on this and I have > > gotten conflicting answers. > > Depends on the version. In Mysql version 4.1.2 and later, the InnoDB > engine will build the index automatically. Prior versions needed the > index to be created beforehand, and then specified when you're actually > declaring the FK. > > > They way mysql works, is this the same for all databases? > > Yes, the same for all databases, because this is version-dependant > behavior. > > -- > I think I'd like to see a Simpsons episode starting up with Bart Simpson > writing "I will not attempt to undermine the Usenet Cabal". > * * * * * * * -- J. D. Falk Hey Peter, Thanks for clearing that up.
|
Linear Mode
