Re: Index not being used
| От | Josh Berkus |
|---|---|
| Тема | Re: Index not being used |
| Дата | |
| Msg-id | web-694398@davinci.ethosmedia.com обсуждение исходный текст |
| Ответ на | Re: Index not being used (Matthew Price <pricem@juno.com>) |
| Ответы |
Re: Index not being used
|
| Список | pgsql-sql |
Matthew, 1. Is field cdate DATE or TIMESTAMP? 2. What happens with: EXPLAIN SELECT cdate FROM sometable WHERE cdate = '2001-02-14'::DATE orTIMESTAMP? 3. Please time both queries and give the number of resulting rows fromboth queries. -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
В списке pgsql-sql по дате отправления: