MySQL is to use the ORDER BY RAND() clause. This can work fine for small tables. However, for big tabl... s** you have created in the tables. In MySQL, you can do this with the EXPLAIN statement. Check status variable "**Select_scan**", "**Select_full_join**".
* With MyISAM tables that have no deleted rows, you can insert rows at the end at the same time that anot
