分析RavenDB的索引功能
I am currently teaching a course in RavenDB, and as usual during a course, we keep doing a lot of work that pushes what we do with RavenDB. Usually because we try to come up with new scenarios on the fly and adapting to the questions from the students.
In this case, we were going over the map/reduce stack and we kept coming more and more complex example and how to handle them, and then we got to this scenario.
Given the following class structure:
2.{
3.public string Name { get; set; }
4.public string Species { get; set; }
5.public string Breed { get; set; }
6.}Give me the count of all the species and all the breeds. That is pretty easy to do, right? In SQL, you would write it like this:
2.GROUP BY Species, Breed
In this case, we were going over the map/reduce stack and we kept coming more and more complex example and how to handle them, and then we got to this scenario.
Given the following class structure:
CODE:
1.1: public class Animal2.{
3.public string Name { get; set; }
4.public string Species { get; set; }
5.public string Breed { get; set; }
6.}Give me the count of all the species and all the breeds. That is pretty easy to do, right? In SQL, you would write it like this:
CODE:
1.SELECT Species, Breed, Count(*) FROM Animals2.GROUP BY Species, Breed
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/301743/viewspace-751075/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【索引】使用索引分析快速得到索引的基本資訊索引
- MySQL的索引分析MySql索引
- 索引分析索引
- Oracle表與索引的分析及索引重建Oracle索引
- oracle 索引分析及索引重建Oracle索引
- Oracle表與索引的分析及索引重建(轉)Oracle索引
- 索引的分析和比較索引
- 分析索引快速獲取索引資訊索引
- [轉]:bitmap索引和B*tree索引分析索引
- MySQL的索引優化分析(一)MySql索引優化
- MySQL的索引優化分析(二)MySql索引優化
- Oracle對索引分析的優化Oracle索引優化
- MongoDB索引,效能分析MongoDB索引
- MySQL索引效能分析MySql索引
- 分析索引是否有效索引
- 超簡單實現iOS列表的索引功能iOS索引
- Oracle對錶、索引和簇的分析Oracle索引
- 索引在ORACLE中的應用分析索引Oracle
- ORACLE分析表和索引的指令碼Oracle索引指令碼
- oracle 表分析和索引Oracle索引
- 分析索引是否變'壞'索引
- Analyze分析表或者索引索引
- 一文總結分析聚集索引、非聚集索引、覆蓋索引的工作原理!索引
- 利用Oracle的全文索引實現切詞功能Oracle索引
- oracle聯合索引在CBO下的分析Oracle索引
- oracle的B-tree索引結構分析Oracle索引
- FOSCommentBundle功能包:指南索引頁索引
- 分析index降低索引層次Index索引
- 2 mysql索引優化分析MySql索引優化
- ORACLE 組合索引 使用分析Oracle索引
- Oralce中分析表及索引索引
- oracle 定期表及索引分析Oracle索引
- MySQL 索引 效能分析 show profilesMySql索引
- 關於SQL Server 2008的缺失索引功能SQLServer索引
- ceph的配額功能分析
- delete語句對索引的影響之分析delete索引
- MySQL 5.7 ANALYZE TABLE分析索引的統計資訊MySql索引
- 索引關鍵字的隱式轉換分析索引