Hi Robert,
On Tue, Apr 1, 2008 at 1:01 PM, Robert DiFalco <[EMAIL PROTECTED]> wrote:
> I've been told that an index always contains the primary key. So if I
A non-primary key index, in InnoDB, contains the primary key values at
the leaf nodes. However it does not contain them at the non-leaf
nod
Hi !
Robert DiFalco wrote:
Right, the proof is that if I have an PKEY on ID and an index just on
VALUE in MySQL then a query that would use both ID and VALUE works fine
with just the index on VALUE.
An index is a means to speed up access to the data when the most
identifying thing, the primar
Right, the proof is that if I have an PKEY on ID and an index just on
VALUE in MySQL then a query that would use both ID and VALUE works fine
with just the index on VALUE.
For Oracle, I need an explicit compound index (in addition to the PKEY)
on (ID,VALUE).
The results on MySQL get a little blur
There is already a primary key index on ID.
-Original Message-
From: Wm Mussatto [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2008 10:50 AM
To: mysql@lists.mysql.com
Subject: Re: Indices in InnoDB/MySQL
On Tue, April 1, 2008 10:01, Robert DiFalco wrote:
> I've been told
At 10:01 AM -0700 4/1/08, Robert DiFalco wrote:
I've been told that an index always contains the primary key.
By who?
Ask for proof.
So if I
have a LONG ID that is the primary key of table and create on index on
LONG VALUE, the index on LONG VALUE will actually work as a typical
compound i
On Tue, April 1, 2008 10:01, Robert DiFalco wrote:
> I've been told that an index always contains the primary key. So if I
> have a LONG ID that is the primary key of table and create on index on
> LONG VALUE, the index on LONG VALUE will actually work as a typical
> compound index on ID,VALUE. My
Those types of queries will be available soon as the INFORMATION_SCHEMA
views are in development. Keep your eyes on the next few releases of
MySQL for this feature to appear (it may already be active in the 5.0.2
release just announced but I haven't had time to check yet). Until then
you will
[EMAIL PROTECTED] wrote:
Hi,
Thank you. But I want select the constraints and indices used on the
table. How can we get this information?. Please help me in this.
Ian gave you the answer:
From: Ian Sales
[...]
- show indexes from DATABASE_NAME.TABLE_NAME
The syntax is: SHOW INDEX FROM tablenam
(WT01 - TELECOM SOLUTIONS)
Cc: [EMAIL PROTECTED]
Subject: Re: Indices and Constraints.
[EMAIL PROTECTED] wrote:
>Need to know the similar one in MySQL. Do we have views or any other
>system tables in MySQL 4.0.21 which OUTPUTS the constraints and
indices
>in a particular table?
&g
[EMAIL PROTECTED] wrote:
Need to know the similar one in MySQL. Do we have views or any other
system tables in MySQL 4.0.21 which OUTPUTS the constraints and indices
in a particular table?
- show indexes from DATABASE_NAME.TABLE_NAME
- or, show create table DATABASE_NAME.TABLE_NAME;
- ian
--
My
Thats usually setup in the same table schema no ?
On 02/12/2004, at 9:52 PM, <[EMAIL PROTECTED]> wrote:
Hi All,
In oracle I can query user_constraints, user_indexes for getting the
constraints and indices for a particular table.
User_constraints and user_idexes are view which holds all the
constra
On Tuesday 18 March 2003 02:47, dreq jkj wrote:
> I have trouble figuring out how the indices are used when making a query
> that uses OR-operator.
>
> If I have the following table:
>
> create table testing(
> id int unsigned not null primary key auto_increment,
> idx1 int unsigned not null,
> id
On Saturday 01 March 2003 01:26, Henning Schulzrinne wrote:
> Both email columns have the same format (varchar) and are indexed
> individually:
>
> describe SELECT person FROM person WHERE email1='foo' OR email2='foo';
> ++--+---+--+-+--+---+--
On Tue, 21 Aug 2001 18:55:15 +0400
Spirit <[EMAIL PROTECTED]> wrote:
> Hello!
>
> I need your suggestions on what keys to build for the table described
> below. Currently I have almost all possible keys on the table in order
> to see what keys mysql will use.
>
> I have a table here, which cons
14 matches
Mail list logo
