How long do the same queries take to run directly on SQL Server?
> On Nov 24, 2016, at 1:15 PM, Sanjiv Kumar <[email protected]> wrote: > > Hello > I have sql server databases having 1 million of data. I am using > drill in window having 1.8 version. And Its running in embedded mode. > > While firing select query, it will take almost 1 hour to run the > query. > > Even i have given limit also it will take 1 hour to run. > > I am executing this query:- select * from demoplugin.dbo.category limit 5; > > Even this query also take 1 hour to show output. > Please tell some solution for that. > > -- > Thanks & Regards. > Sanjiv Kumar.
