Re: Specifying an index length and the default value

2004-05-30 Thread David Griffiths
riginal Message - From: "David Griffiths" Sent: Friday, May 28, 2004 6:05 PM Subject: Specifying an index length and the default value The length of indexes on varchar and char indexes can be specified at index creation. What is the default length of an index if no length is provided?

Re: Specifying an index length and the default value

2004-05-30 Thread Matt W
Hi David, Great questions: - Original Message - From: "David Griffiths" Sent: Friday, May 28, 2004 6:05 PM Subject: Specifying an index length and the default value > The length of indexes on varchar and char indexes can be specified at > index creation. > > What

Specifying an index length and the default value

2004-05-28 Thread David Griffiths
The length of indexes on varchar and char indexes can be specified at index creation. What is the default length of an index if no length is provided? The High Performance MySQL book hints that the index-length used is specific for each entry in the indexed column (ie an index on a column where