Hi again! I collected some information from Plan Text of my queries and i want to analyze them.
First of all, i have no indexes on my database, just a primary index. So, using Plan Tree information i want to figure out why some queries are slower than others. Trying to do this i realized that i can’t undestand or find enough information about what is a ‘Sequence’ operator, an ‘InitialProject’ operator, a ‘Fetch’ operator, a ‘Stream’ or a ‘Final Project’ operator.
As about times, i’ve read the Filter taking too long - #3 by pccb question defining execTime, kernTime and servTime, but still i cannot understand the operators in Plan Text in order to find out why some queries are slower than others, clearly.