Re: difference between KEY and INDEX

2003-10-31 Thread Roger Baklund
th other databases > = > > But I think maybe KEY and INDEX same practically. > > If keys and indexes are not same, Could anyone let me know what > is different between KEY and INDEX ?? KEY and INDEX is the same, the ab

difference between KEY and INDEX

2003-10-31 Thread À±Á¤ ±è
But I think maybe KEY and INDEX same practically. If keys and indexes are not same, Could anyone let me know what is different between KEY and INDEX ?? _ Protect your PC - get McAfee.com VirusScan

difference between KEY and INDEX

2003-10-31 Thread Yuen-Jeong Kim
= But I think maybe KEY and INDEX same practically. If keys and indexes are not same, Could anyone let me know what is different between KEY and INDEX ?? _ MSN 8 helps eliminate e-mail viruses. Get

difference between KEY and INDEX

2003-10-31 Thread 김 윤정
databases = But I think maybe KEY and INDEX same practically. If keys and indexes are not same, Could anyone let me know what is different between KEY and INDEX

Re: KEY and index

2001-06-23 Thread Daniel Åkerud
They most certainly do depend on the table design and especially on the system which runs the test. They are my own figures... > Daniel Åkerud wrote: > > In MySQL having a table that looks like this: > > > > idint primary key > > namechar(200) > > > > and making an index on name, will ge

Re: KEY and index

2001-06-23 Thread Eric Persson
Daniel Åkerud wrote: > In MySQL having a table that looks like this: > > idint primary key > namechar(200) > > and making an index on name, will get you a 0.1 * original_retrieval_time > when searching, but 1.5*original_insertion_time when inserting. It roughly > means that (on my system

Re: KEY and index

2001-06-23 Thread Daniel Åkerud
rco Bleeker" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, June 22, 2001 9:36 AM > > Subject: KEY and index > > > > > > > Hello, I am learning MySQL and have a question. I know about the > > importance > > &

Re: KEY and index

2001-06-23 Thread Benjamin Pflugmann
Hello. On Sat, Jun 23, 2001 at 01:01:41AM +0020, [EMAIL PROTECTED] wrote: > I understand that indexes work so fast because they are usually smaller than the > original table, since they contain on average just 1 column, or at least less > information than the complete table. But how about a tab

Re: KEY and index

2001-06-22 Thread botanicus
same 2 columns speed up processing, more specific, would it speed up a SELECT WHERE (the WHERE clause being related to the index algoritm) Thanks, Marco > - Original Message - > From: "Marco Bleeker" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sen

Re: KEY and index

2001-06-22 Thread Daniel Åkerud
Friday, June 22, 2001 6:27 PM Subject: Re: KEY and index > KEY is used to build other indexes. It's not short for Primary Key. There > are PRIMARY KEY indexes, candidate key indexes (these COULD be a primary key > but for one reason or another , are not) and just regular indexes. &g

Re: KEY and index

2001-06-22 Thread Cal Evans
ng and updating records. HTH, Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: "Marco Bleeker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 22, 2001 9:36 AM Subject: KEY and index > Hello, I am le

KEY and index

2001-06-22 Thread Marco Bleeker
Hello, I am learning MySQL and have a question. I know about the importance of the PRIMARY KEY statement, but I also see a KEY statement being used when creating a table. Is this just short for PRIMARY KEY, or what's the difference? Second question, when I have a large table, but with only 2 s