Using index from sub-query
От | pdaly |
---|---|
Тема | Using index from sub-query |
Дата | |
Msg-id | 39AA844A.B2C6F5DD@ix.netcom.com обсуждение исходный текст |
Ответ на | Local Users "su'ing" (andrew@ugh.net.au) |
Ответы |
Re: Using index from sub-query
|
Список | pgsql-general |
As has been talked about recently, I have a int8 field, which when searched for as 'value' will use the index, but as value, with the quotes will not. I subquery to get a list of the values to look up: SELECT [fields] FROM table1 WHERE id in ( select distinct id from namelookup where name = '$tname' ) When I do an explain on this, it is doing a table scan, and not using the index table1. It will only use the index when the value to be matched is in quotes. How can I force it to use the index, or create a new index which would be used. This causes a HUGE performance hit. (30-45 seconds, as opposed to less than 1 second.) Any help would be greatly appreciated! -Pete
В списке pgsql-general по дате отправления: