, Anna
Cc: '[EMAIL PROTECTED]'
Subject: Re: [ADMIN] seq scan on indexed column
On Thu, 14 Mar 2002, Zhang, Anna wrote:
> gtld_analysis=# explain SELECT NETBLOCK_START
> gtld_analysis-# FROM GTLD_OWNER
> gtld_analysis-# WHERE NETBLOCK_START = -2147483648;
You might want to try
On Thu, 14 Mar 2002, Zhang, Anna wrote:
> gtld_analysis=# explain SELECT NETBLOCK_START
> gtld_analysis-# FROM GTLD_OWNER
> gtld_analysis-# WHERE NETBLOCK_START = -2147483648;
You might want to try the same query but with the constant integer
enclosed in single quotes. I find that (at least for
zabo, Could you please take a look, I know you can help!!!
Anna Zhang
-Original Message-
From: Zhang, Anna [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 3:34 PM
To: '[EMAIL PROTECTED]'
Subject: [ADMIN] seq scan on indexed column
Hi,
I always have question
Hi,
I always have questions on sql tunning, here is the one:
gtld_analysis=# \d gtld_owner
Table "gtld_owner"
Attribute| Type | Modifier
++
owner_name | character varying(100) |
netblock_star
