user defined veriable in sub select

1 post / 0 new
haresh.patel
haresh.patel's picture
Offline
Last seen: 5 months 3 days ago
Joined: Oct 8 2013
Junior Boarder

Posts: 2

Haresh Patel
user defined veriable in sub select

Hello,

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.