I have a query which is using 4 tables, all the tables are properly indexd for the query. When i ran the query for the first time it took around 5 min. When i saw the trace out put , it was using the idexes.

After this I had analyzed all the the 4 tables. This time the ouput came within 20 sec. But i saw that it using a full table scan.

Why a full tablescan is faster after the table are analyzed ?

Thanks in advance