site index on (master_id, ticket_id)? Since your queries
>are selecting on a particular master_id, and ordering by ticket_id, along
>with the limit I think MySQL would be able to use such an index in an
>optimization.
>
>-Daniel
>
>-Original Message-
>From: Terence
id`) REFERENCES
> `helpdesk_sub_category_master` (`sub_category_id`),
> FOREIGN KEY (`category_id`) REFERENCES `helpdesk_category_master`
> (`category_id`)
> ) TYPE=InnoDB CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free:
> 97280 kB'
>
> Daniel wrote:
>
>
g by ticket_id, along
with the limit I think MySQL would be able to use such an index in an
optimization.
-Daniel
-Original Message-
From: Terence [mailto:[EMAIL PROTECTED]
Sent: Friday, May 27, 2005 10:52 PM
To: mysql@lists.mysql.com
Subject: performance on single column index with few di
On 5/28/05, Terence wrote:
>
> Master ID is used to distinguish multiple helpdesks. In this table there
> are 100k records, but only 10 distinct master_id's.
>
> ticket_id master_id
> 1 1
> 2 1
> 3 2
> 4 2
> 5 3
> ...
PROTECTED]
Sent: Friday, May 27, 2005 10:52 PM
To: mysql@lists.mysql.com
Subject: performance on single column index with few distinct values
Hi list,
I have run into problems on a master table for our helpdesk. We have the
following table:
ticket_id (int) - autoincrement (indexed)
master_id
Hi list,
I have run into problems on a master table for our helpdesk. We have the
following table:
ticket_id (int) - autoincrement (indexed)
master_id (int) (indexed)
Master ID is used to distinguish multiple helpdesks. In this table there
are 100k records, but only 10 distinct master_id's.