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,
Can any let me know which will is better one in performance and also I like to know what exactly this headers mean??
Karthick response means:
I have no idea what "10 crore of data" is. use thousand, million, billion, trililon, etc.
> I have no idea what "10 crore of data" is. use thousand, million, billion, trililon, etc.
Google/Bing/Yahoo is your friend. If you are really interested, general knowledge and patience will help you helping others from across world or searching this own forum for the word.
In general a plan with lesser Cost is considered as efficient. AFAIK Cost is kind of number which the query optimizer has predicted/derived for that statement to execute. Cardinality is the number of records predicted by the optimizer for a table or for a Join method. Im not very sure of what Bytes column is exactly - but i believe its of less important. Eventually your main concern must be on the value of the column Cost - when you want to compare execution plans.