Hi all,
Can someone explain to me what the benefits of using one table type over another may be? I currently work with MySQL, and have read up on what exactly each type (MyISAM, ISAM, heap) entails, but I'm still not sure as to why each type exists. Is this just a MySQL thing (i'm assuming that MyISAM is special to MySQL)? I've previously worked (briefly) with Postgres, but I never got into table types, so I do not know what the big P's take on them is.
This is merely a fact-finding post...there's no job that depends on the answer to this. So answer when you get a minute!
Thanks....
Can someone explain to me what the benefits of using one table type over another may be? I currently work with MySQL, and have read up on what exactly each type (MyISAM, ISAM, heap) entails, but I'm still not sure as to why each type exists. Is this just a MySQL thing (i'm assuming that MyISAM is special to MySQL)? I've previously worked (briefly) with Postgres, but I never got into table types, so I do not know what the big P's take on them is.
This is merely a fact-finding post...there's no job that depends on the answer to this. So answer when you get a minute!
Thanks....