> 1. So from an oracle perspective ZFS makes updates/deletes fast but full table scans are >slow - this is bad :(
I'm by no means a database expert. But haven't the full table scans improved in the last years? Maybe in this particular case there is a performance hit, where read-ahead might perform well enough. But then again, the update/delete of random data was probably faster... There was an interesting thread a while ago: http://www.opensolaris.org/jive/thread.jspa?messageID=14997 # mv Disclaimer.txt /dev/null ------------------------------------------------------------------------- This message is intended for the addressee only and may contain confidential or privileged information. If you are not the intended receiver, any disclosure, copying to any person or any action taken or omitted to be taken in reliance on this e-mail, is prohibited and may be un- lawful. You must therefore delete this e-mail. Internet communications may not be secure or error-free and may contain viruses. They may be subject to possible data corruption, accidental or on purpose. This e-mail is not and should not be construed as an offer or the solicitation of an offer to purchase or subscribe or sell or redeem any investments. ------------------------------------------------------------------------- _______________________________________________ opensolaris-discuss mailing list [email protected]
