On Feb 8, 2012, at 10:14 AM, Danil ŢORIN wrote: > For example if you only query data for 1 month intervals, and you > partition by date, you can calculate in which shard your data can be > found, and query just that shard.
This is what one calls "partition pruning" in database terms. http://en.wikipedia.org/wiki/Partition_(database) http://www.orafaq.com/tuningguide/partition%20prune.html Rather handy way to scale to "infinity and beyond" as Buzz Lightyear would have it. Perhaps of interest: Scaling to Infinity – Partitioning in Oracle Data Warehouses http://www.evdbt.com/TGorman%20TD2009%20DWScale.doc http://www.evdbt.com/OOW09%20DWScaling%20TGorman%2020091013.ppt --------------------------------------------------------------------- To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org For additional commands, e-mail: java-user-h...@lucene.apache.org
