Oh, sorry, you are trying to do a LIKE. Indexes cannot be used for LIKE operations with left and right wildcars
Thanks Luigi 2017-10-23 10:08 GMT+02:00 Luigi Dell'Aquila <[email protected]>: > Hi, > > The query seems to be correct, could you please post a simple SQL script > to reproduce the exact case? > > Thanks > > Luigi > > > > 2017-10-21 10:42 GMT+02:00 <[email protected]>: > >> Hai, >> >> METADATAPROPERTIESINOUT >> >> @rid >> @class >> @version >> mobile_no >> created_date >> email_id >> name >> is_deleted >> gender >> network_id >> store_customer >> customer_has_appointment >> customer_has_billing >> customer_has_store_service >> customer_has_preferred_stylest >> customer_has_wallet_inventory >> customer_has_wallet_activity >> customer_has_customer_feedback >> customer_has_activity >> #260:103808 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/260:103808> >> customer 11 1111111131 2017-10-14 17:17:34 [email protected] Santhosh false >> male #25:2049 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/25:2049> >> #297:106317 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/297:106317> >> #351:15393 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/351:15393> >> #339:13080 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/339:13080> >> #302:18050 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/302:18050> >> #346:16985 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/346:16985> >> #443:420 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/443:420> >> #438:1198 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/438:1198> >> #280:37779 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/280:37779> >> #261:135035 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/261:135035> >> >> we have index the *customer* vertex as* customer.network_id_mobile_no* >> >> i want to query on index like, *network_id = #25:2049 >> <http://192.168.1.40:2480/studio/index.html#/database/mio/browse/edit/25:2049> >> and mobile_no >> like '%1131%'* >> >> Below i have wrong query, can u modify it as per my requirement, >> >> select from index:customer.network_id_mobile_no where key = [#25:2049, >> '%111131%'] >> >> Thanks and Regards, >> T.Pugazhararasan. >> >> -- >> >> --- >> 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. >> > > -- --- 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.
