In reading the syntax of the CREATE TABLE statement, I'm a little confused
by the two keywords KEY and INDEX.
What does one use when one wants MySQL to arrange the column so that it can
find a given record WHERE column=whatever in approximately O(log N) time?
This is a key, right? MySQL uses
Hi,
David T. Ashley wrote:
In reading the syntax of the CREATE TABLE statement, I'm a little confused
by the two keywords KEY and INDEX.
What does one use when one wants MySQL to arrange the column so that it can
find a given record WHERE column=whatever in approximately O(log N) time
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
=
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
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
=
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 above excerpt from the manual is about the
PRIMARY
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 table
, 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]
Sent: Friday, June 22, 2001 9:36 AM
Subject: KEY and index
Hello, I am
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 that
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 get you a 0.1
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 learning MySQL and have a question. I
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.
All tables should have a primary key. (I'm partial to adding
On Sat, Feb 24, 2001 at 09:43:45AM -0700, Karl Stubsjoen wrote:
I'm trying to understand MySQL indexing but am having trouble
understanding the differnences (and when to use each) between
Primary Key, Key, Unique, an Index. Can you help?
Index and Key are the same.
A Primary Key
Hello,
I'm trying to understand MySQL indexing but am having trouble understanding the
differnences (and when to use each) between Primary Key, Key, Unique, an Index. Can
you help?
Thank you!
On Sat, Feb 24, 2001 at 09:43:45AM -0700, Karl Stubsjoen wrote:
I'm trying to understand MySQL indexing but am having trouble
understanding the differnences (and when to use each) between
Primary Key, Key, Unique, an Index. Can you help?
Index and Key are the same.
A Primary Key
15 matches
Mail list logo