Hi sojan
this will help you !!
Update statistics has three major functions:
a) Compile Stored Procedures
b) Dropping / Creating Data distributions
c) Collecting Statistics for the Optimizer
The improvements in the new release concentrate on b) and c). There are no significant changes to the...
Hi Kalpana/lloyd
Update statistics (Low|Medium|High)
Update low mode , no data distribution is created
low mode updates only the statistics in the
systables,syscolumns and sysindexes system catalog tables.
if a mode is not specified then default low mode is used.
Best I feel used Update...
Hi
please try this in your query
for example
set explain on ;
select * from a;
set explain off
it's create sqexplain.out file
please check that file
Regards
Hiten
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.