Skip to main content

Home/ BI-TAGS/ Group items tagged dba

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
cezarovidiu

Remote Oracle DBA Support : SQL*Net message to dblink , SQL*Net message from dblink - 0 views

www.moreajays.com/...-to-dblink-sqlnet-message.html

oracle dba hint apps DW

shared by cezarovidiu on 02 Sep 13 - No Cached
  • cezarovidiu on 02 Sep 13
     
    "/*+ DRIVING_SITE (hr)*/  /*+ DRIVING_SITE (hc)*/ /*+ DRIVING_SITE (hp1)*/ "
cezarovidiu

mysql - Best of MyISAM and InnoDB - Database Administrators - 0 views

dba.stackexchange.com/...best-of-myisam-and-innodb

mysql performance

shared by cezarovidiu on 21 Mar 13 - No Cached
  • Some people can make the table's row format FIXED using ALTER TABLE mydb.mytb ROW_FORMAT=Fixed; and can get a 20% increase in read performance without any other changes. This works and works effectively FOR MyISAM. This will not produce faster results for InnoDB because ... that's right ... you must consult the gen_clust_index each time.
1 - 8 of 8
Showing 20▼ items per page