Jeremy Chase InnoDB interaction between secondary and primary keys.
Jan 30, 2013; 14:25
Jeremy Chase
InnoDB interaction between secondary and primary keys.
Hello,
I've been working with a secondary index and would like some clarification about how the primary columns are included. So, in the following example, is the secondaryKey effectively the same as redundantKey?
"In InnoDB, each record in a secondary index contains the primary key columns for the row, as well as the columns specified for the secondary index."
Thank you! Jeremy
Jan 30
Rick James RE: InnoDB interaction between secondary and primary keys.
Jan 30, 2013; 21:07
Rick James
RE: InnoDB interaction between secondary and primary keys.
Jan 30
Rick James RE: InnoDB interaction between secondary and primary keys.
Jan 30, 2013; 21:24
Rick James
RE: InnoDB interaction between secondary and primary keys.
Feb 01
Jeremy Chase Re: InnoDB interaction between secondary and primary keys.
Feb 01, 2013; 15:18
Jeremy Chase
Re: InnoDB interaction between secondary and primary keys.
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!