I have a table like this CREATE TABLE IF NOT EXISTS `tbl_folder` ( `id` int(11) NOT NULL AUTO_INCREMENT,
I have a view V2 that selects from another view V1 and adds a couple predicate filters. V2 IS SELECT * FROM V1
I have a MySQL 5.0 query regularly taking 14+ seconds, called from a web page, and users are impatient. It\'s fairly simple, selecting 11 columns from 2 tables. I have three questions:
if I run this query select user from largetable wh开发者_开发百科ere largetable.user = 1155 (note I\'m querying user just to reduce this to its simplest case)
I want to capture execution plan only for long running 开发者_开发技巧query (5 minutes) for this I have used extended event but the plan_handle which is returned by extended events does not produce an
I have a view and I want to query my view like that to hint some index from a base table,can I do that?
I have a sql query in python which is pretty slow, it contain some inner join, And some one suggest that in this case we can:turn on the \"Show Actual Execution Plan\" option and then take a close lo
I have a query that according to my slow query log it\'s a bit slow.... Query_time: 8.408943Lock_time: 0.000119 Rows_sent: 1Rows_examined: 2911766
In SQL Server 2005 management studio I am testing a query which uses some table variables, one of which has a clustered unique constraint on it.I am noticing that the total execution time actually goe
I\'ve come across a query that is taking \"too long\". The query has 50+ left joins between 10 or so tables. To give a brief overview of the database model, the tables joined are tables that store dat
加载中,请稍侯......