Hi!! My class ActivityLog have two property. createdAt(datetime) userNo(long)
and I make index each column. and my query is 'SELECT userNo, count(userNo) FROM ActivityLog WHERE createdAt BETWEEN '2015-08-01 00:02:17' AND '2015-08-01 12:02:17' GROUP BY userNo' orientdb log say "Query 'SELECT FROM activityLog WHERE createdAt BETWEEN '2015-08-01 14:29:55' AND '2015-08-02 17:29:55' AND type = 'LO' GROUP BY userNo' fetched more than 50000 records: to speed up the execution, create an index or change the query to use an existent index [OEnterpriseProfiler]" how can i make index using group by? -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
