1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

explain the options of myisamchk to improve the performance of a table. : Sql dba

Question Posted / himanshu


explain the options of myisamchk to improve the performance of a table. : Sql dba..

Answer / Pooja Rani Vishnoi

MyISAMCHK is a command-line utility for MyISAM tables. Some options include: --sort-recursive (to sort the indexes recursively), --analyze (to rebuild the distribution statistics for each table), --block-size=<value> (to set the block size for the recovered data files), and --quick (to skip checking of deleted records).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is auto increment feature in sql?

1 Answers  

What are sql indexes?

1 Answers  

How to create a menu in sqlplus or pl/sql?

1 Answers  

How to execute OS(operating system) command from pl/sql?

3 Answers  

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

Where can I learn sql for free?

1 Answers  

Explain polymorphism in pl/sql.

1 Answers  

What do you mean by dbms? What are its different types?

1 Answers  

How to change sql*plus system settings?

1 Answers  

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

What is fmtonly in sql?

1 Answers  

What is sql prepared statement?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories