On 02/02/17 12:53, Job wrote:
>
> I create a table copy, with indexes, and it worked perfecly.
> Then i dropped the original table and recreated it back by a copy of the newest.
>
> Same problems, lack during searches and indexes not used.
I didn't see your original message so may have missed this, but did you
run ANALYZE on the table after creating it? - Depending on how you
created the table, the statistics needed by the planner may or may not
have been up to date.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie