in reply to Re: Select a random record
in thread Select a random record

The key to lhoward's approach is to index FOO. This is a critical detail: without an index, you're tablescanning again.