Sam Barnett-Cormack <[EMAIL PROTECTED]> writes:
> On Wed, 7 Apr 2004, Hemapriya wrote:
>> Column |Type | Modifiers
>> ---+-+---
>> origindb | character(1)| not null
>> uid | integer | no
On Wed, Apr 07, 2004 at 14:03:54 -0700,
Hemapriya <[EMAIL PROTECTED]> wrote:
> Indexes:
> "request_pkey" primary key, btree (origindb, uid)
>
> I do max Query like this
>
> select max(uid) from request where originDB=1;
>
> it took around 20 min to return the result.. Since
> max, count
On Wed, 7 Apr 2004, Hemapriya wrote:
> Hi,
>
> we have table having 23 million rows.
> This is the table structure.
> Table Request:
>
> Column |Type | Modifiers
> ---+-+---
> origindb | character(1)| not nul
Hi,
we have table having 23 million rows.
This is the table structure.
Table Request:
Column |Type | Modifiers
---+-+---
origindb | character(1)| not null
uid | integer | not null