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
