Difference between Delete and Truncate
if we use truncate table then we can reuse storage. all memory is free for other operation not wait for any cleanup operation in truncate while in delete the memory is not available for further use.
Difference between count() and count(*)
In count(*) include duplicate null values while in count() not include null value
if we use truncate table then we can reuse storage. all memory is free for other operation not wait for any cleanup operation in truncate while in delete the memory is not available for further use.
Difference between count() and count(*)
In count(*) include duplicate null values while in count() not include null value
No comments:
Post a Comment