How to reclaim space from a fragmented allpages heap table?
A. run reorg command
B. dump and load the database
C. create and drop a clustered index
D. truncate the least used pages
Submitted by: AdministratorC. create and drop a clustered index
Submitted by: Administrator
Submitted by: Administrator
Read Online Sybase Certification Job Interview Questions And Answers
Top Sybase Certification Questions
☺ | Explain When you run optdiag command on a allpages-locked table with 1000 |
☺ | Where are table/index level statistics stored? |
Top Certifications Categories
☺ | CCIE Certification Interview Questions. |
☺ | CCSP Certification Interview Questions. |
☺ | AFMC Interview Questions. |
☺ | Sun Certification Interview Questions. |
☺ | GATE Exam Interview Questions. |