Index lookup on > and < criteria
От | David Durham |
---|---|
Тема | Index lookup on > and < criteria |
Дата | |
Msg-id | 4367B16B.2050003@vailsys.com обсуждение исходный текст |
Ответы |
Re: Index lookup on > and < criteria
Re: Index lookup on > and < criteria |
Список | pgsql-sql |
Apologies if this questions is asked often. I'm doing some select statements based on a timestamp field. I have an index on the field, and when I use the '=' operator the index is used. However, if I use the '>' or '<' operators, then it does a full table scan. I've got around 6 million rows, so I would think that an index scan would be more appropriate. Here are the statements I'm looking at: select * from myTable where myTimeStamp = '10/1/2005'; uses an index. select max(myTimeStamp) from myTable; select * from myTable where myTimeStamp < '10/2/2005'; select * from myTablewhere myTimeStamp < '10/2/2005' and myTimeStamp >= '10/1/2005'; do not use indexes. Can anyone point me to some info about what's going on? I've started reading through the manual (chapter 13) which I think explains query optimizing, index usage etc. It seems like this would be a common enough problem that it would have a relatively simple solution. Thanks. -Dave
В списке pgsql-sql по дате отправления: