Title: 네이버 메일
 |
|
|
박찬민 (naracom2002) 님께 보내신 메일 <Re: compound primary key>
이 다음과 같은 이유로 전송 실패했습니다.
|
| -------------------------------------------- |
|
|
수신자의 메일 보관 용량이 가득차 있습니다. 나중에 다시 시도하십시오.
|
|
| -------------------------------------------- |
|
--- Begin Message ---
On Mon, Jan 21, 2002 at 05:18:35PM +0100, Roger Baklund wrote:
> Hi,
>
> Also, I wonder what is the best order for my primary keys:
>
> a int This is the 'main' id, very many distinct values
> b tinyint This is a source code, possible values are 1 or 2
> c smallint Some counter
> d tinyint Another counter
>
> or
>
> b tinyint This is a source code, possible values are 1 or 2
> a int This is the 'main' id, very many distinct values
> c smallint Some counter
> d tinyint Another counter
>
> Which will perform faster, when all lookups use both a and b?
Is this helpful at all?
http://www.linux-mag.com/2001-06/mysql_01.html
It covers compound indexes (among other topics).
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 19 days, processed 440,731,871 queries (264/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--- End Message ---
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
