on 11-23-2009 5:20 PM
Hi,
How to build stats on particular table.Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
at OS level:
brconnect -c -u / -f stats -t Your_table
at SAP level:
transaction DB20
>
> at OS level: > > brconnect -c -u / -f stats -t Your_table
> at OS level:
> brconnect -c -u / -f stats -t Your_table
with that command BRCONNECT will check if the table needs statistics and will calculate them if so.
if you want to force the collection (no checking if they are needed) then you need to run the following command:
brconnect -c -u / -f stats -t Your_table -f collect
It would be very helpfull for you if you check the documentation at help.sap.com and , all this information is there.
Why do we need to buid stats for a table.What exactly happens if we build a stats for table.Thanks in advance.
ok, another interview question?
Got attend SAP courses ADM100 and ADM515.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.