Re: [PERFORM] QRY seems not using indexes

Qingqing Zhou wrote: <[EMAIL PROTECTED]> writes so, if I do a qry like "EXPLAIN ANALYZE select * from pridecdr where idsede=8977758488" it tooks a lot of time before i get back any result: Index Scan using prd_id_sede on pridecdr (cost=0.00..699079.90 rows=181850 width=138) (actual time=51.2

Re: [PERFORM] QRY seems not using indexes

<[EMAIL PROTECTED]> writes > > > so, if I do a qry like "EXPLAIN ANALYZE select * from pridecdr where > idsede=8977758488" it tooks a lot of time before i get back any result: > > Index Scan using prd_id_sede on pridecdr (cost=0.00..699079.90 > rows=181850 width=138) (actual time=51.241..483068.2