ethanasi wrote:That maybe means the table stats are not up-to-date.
This is what is puzzling me.
ethanasi wrote:Which is the wrong proc, you should use DBMS_STATS.GATHER_TABLE_STATS() or DBMS_STATS.GATHER_INDEX_STATS() instead
I ran: ANALYZE table nota compute statistics;
ANALYZE INDEX idx_nota_nip COMPUTE STATISTICS;
Sometimes, it doesn't take geniuses to resolve problems.No, of course, just thinking a little bit and read the book.
ethanasi wrote:No, not at all. You misunderstood the key point.
If there are books then why there are forums also?
Just to tell other people that there are books?
AFAIK forums exists so more experienced people help others like me.
Because the cost-based optimizer sucks in 10g.Can't someone explain which might be the reasons the query doesn't use the index?
Sometimes, it doesn't take geniuses to resolve problems.Good too as not many of them here
If there are books then why there are forums also?Books require effort to read them while forums will spoonfeed the information to the lazy.
being not so fond of command lineBecause you do not know the commands yes?