adspace


what is the difference between myisam static and myisam dynamic? : Sql dba

Answer Posted / Shishpal

MyISAM Static tables have a fixed table size, which means they cannot be resized once created. MyISAM Dynamic tables can be resized as needed by adding or removing rows from the data file (.MYD).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do we need to rebuild index after truncate?

1154


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


what is schema? : Sql dba

1163


how many tables will create when we create table, what are they? : Sql dba

1156


If a cursor is open, how can we find in a pl/sql block?

1252


what are aggregate and scalar functions? : Sql dba

1142


define sql insert statement ? : Sql dba

1110


what are all the common sql function? : Sql dba

1141


what is dbms? : Sql dba

1070


how to use regular expression in pattern match conditions? : Sql dba

1125


What is the current version of sql?

1106


What is the current version of postgresql?

1188


Can we rollback truncate?

1083


Does group by remove duplicates?

1120


How do I remove duplicates in two columns?

1202