user defined veriable in sub select

1 post / 0 new
haresh.patel's picture
Last seen: 7 months 1 day ago
Joined: Oct 8 2013
Junior Boarder

Posts: 2

Haresh Patel
user defined veriable in sub select


I have set "infinidb_vtable_mode=2" for my query which s not supported by infindb engine.

but then all of my query also work slow and than result exectuion process take 1 minutes time.

my query took 30 seconds.

is there any alternate solution for User defined Veriable Or

How I can get row number without using user defined veraibles.