This discussion is archived
9 Replies Latest reply: Jul 25, 2013 5:01 AM by SomeoneElse RSS

Doubt in explain plan

Shidu Newbie
Currently Being Moderated

Hi,

 

I have written a query which collects some billing details from 1990 to till date and I like to add that I am using single table but it has about 10 crore of data. So the performance is tooooooo bad.

 

When I was tuning the query I found in the explain plan with 2 different tries as follows,

 

COSTCARDINALITYBYTES
17214750334204
162313503

 

Can any let me know which will is better one in performance and also I like to know what exactly this headers mean??

 

Thanks,

Shidu

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points