Computer Science, asked by 38ismyrollno, 2 months ago

define optimize option used in inserted tables... please

Answers

Answered by aaryajoshi41

1

Answer :

Identify Tables for Optimization. The first step is to identify whether you have fragmentation on your MySQL database. ...

Defrag using OPTIMIZE TABLE command. There are two ways to optimize a table. ...

Defrag using mysqlcheck command. ...

Defrag All Tables or All Databases. ...

After Optimization.

Previous Question

Next Question

Similar questions

Geography, 1 month ago

what do you mean by natual resources...

English, 1 month ago

Give 3 what are the different methods of cooking? Give example...

Math, 1 month ago

how many million make 3 crore...

Geography, 2 months ago

write a short note on Brazil wildlife...

Hindi, 2 months ago

पाठ की बात बातों-बातों में 1. यह घटनाक्रम कब का है? 2. कार्यकर्ताओं की नज़र धनपुर पर कैसे पड़ी? 3. धनपुर ने पत्र को नष्ट क्यों नहीं किया? 4. मिलिट्री ने बुढ़िया को क्यों मारा था? 5. असम चारों तरफ़ से किसकी फ़ौज से घिरा थ...

English, 9 months ago

who was the great soldier of persia Class 8 chapter name rustum and sohrab please please please please help me ...

English, 9 months ago

(A) Read the following paragraph carefully. Write the meanings of the word "PRESENT" in the space provided. Last Sunday, attended Ravi's birthday party. All his family members & friends were present (1) there. In the beginning of the party, Ravi's father presented (2) Ms. Mrunalini Guptha, the world number one Kathak artist at present (3). Ms Guptha did present 4) a scintillating show. I...

Geography, 9 months ago

the sun rises two hours earlier in arunachal pradesh as compared to gujarat. what time will the watch show in gujarat if it is 6 am in arunachal pradesh ...