logo
down
shadow

Sql server query using function and view is slower


Sql server query using function and view is slower

Content Index :

Sql server query using function and view is slower
Tag : sql-server , By : Killercode
Date : January 10 2021, 01:57 PM


Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Database Query Slower with View


Tag : sql , By : Alex Bartzas
Date : March 29 2020, 07:55 AM
it should still fix some issue I didn't think the HAVING clause could accommodate what you'd posted, but I believe your view should be written to use UNIONs instead. Here's my take on it:
ALTER VIEW [dbo].[wpvw_v] AS
WITH names AS(
  SELECT k.name
    FROM KVGS k 
   WHERE EXISTS(SELECT NULL
                  FROM CDES c
                 WHERE c.kgi = k.kvgi
              GROUP BY c.kgi
                HAVING COUNT(c.kgi) > 1)
  UNION ALL
  SELECT k.name
    FROM KVGS k 
   WHERE k.mu = 1
GROUP BY k.name
  UNION ALL
  SELECT k.name
    FROM KVGS k 
    JOIN FP x ON x.name = k.name
GROUP BY k.name)
SELECT n.name
  FROM names n
SELECT n.name
  FROM wpvw_v n
 WHERE CHARINDEX(@name, n.name) > 0

SQL Server query runs slower from ADO.NET than in SSMS


Tag : asp.net , By : Frank Rotolo
Date : March 29 2020, 07:55 AM
I think the issue was by ths following , If a bad plan is cached then the same bad plan should be used from SSMS too, if you run the very same query with identical arguments.
There cannot be better solution that finding the root cause. Trying to peek and poke various settings in the hope it fixes the problem will never give you the confidence it is actually fixed. Besides, next time the system may have a different problem and you'll believe this same problem re-surfaced and apply a bad solution.

Why is this MySQL query slower on one server than another?


Tag : mysql , By : Xander
Date : March 29 2020, 07:55 AM
To fix this issue I assume your hardware is the same on both servers.
You can have a look with the profiler where the difference comes from.
SET profiling = 1;
SELECT /*yourquery...*/
SHOW PROFILES;
/*lookup the id for your query*/
SHOW PROFILE FOR QUERY 1 /*or whatever id your query has*/

Query on View is running slower than direct query - in Oracle


Tag : sql , By : Marie Ramos
Date : March 29 2020, 07:55 AM
will be helpful for those in need The execution plan on each statement will give you more detail on what is happening. Try using some of the provided oracle tools for investigating what exactly is happening in each case.
Try doing a:
 SELECT/*+gather_plan_statistics*/ * FROM TABLE(get_data(12345, 'MYTAB'));
 SELECT/*+gather_plan_statistics*/ * FROM my_view

Join function in the query making the query run slower


Tag : php , By : DotNetWise
Date : March 29 2020, 07:55 AM
this one helps. You'll need to index all your columns on which join condition is applied. In your case : "compid" , "c_cod" in both your tables.
Generally, "Primary Key constraint" columns are automatically indexed in databases, though you'll have to index the "Foreign Key constraint" columns manually.
Related Posts Related QUESTIONS :
  • SQL Server Wildcard Length
  • SQL Server : column data extraction
  • The nullability property of arithmetic operators over floating point data type in SQL Server
  • MD5 Hashing in SQL Server
  • How to extract every 7 characters of an nvarchar into another table?
  • ARX Anonymization Tool - supported databases
  • What are good practices for granting database permissions to a web service connection?
  • Go MSSQL Connection
  • SQL Server select query very slow
  • How to delete from multiple tables in one DELETE statement in a .cfc file?
  • Is it possible to get "NT AUTHORITY\NETWORK SERVICE" user independent of language?
  • How to select date and previous date
  • Cleaning dupes and keeping max data
  • Why would adding a simple field to select change the amount of returned rows SQL
  • Read file in SSIS Project into a variable
  • A simple pivot but can't get my head around it - please assist..:-)
  • SQL Server INSERT INTO using transaction
  • How to select from table one with all records from table 2
  • How to migrate collections from TFS 2017 to Azure DevOps Server 2019 (Different DB servers)
  • How to fix error Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ','.?
  • I am getting this error even after declaring scalar variable"'Must declare the scalar variable "@col_shipping_
  • What is the difference between 'CREATE USER [user_name] FOR LOGIN [login_name]' and 'CREATE USER [user_name] FROM LOGIN
  • How to handle a subquery with no results?
  • Access linked to SQL Server shows #Name? in fields after filtering
  • What is different between the two methods of generating cluster primary keys?
  • How can I restore an SQL Server database when starting the Docker container?
  • How to call a SQL Server procedure with both input and output parameters?
  • SQL: Can this be written more efficiently?
  • Why are and are the same in SQL Server
  • date function will return different date if date changes while executing the query?
  • Creating a function for a snap, crackle, pop
  • Difference between SSDT in VS and Integration Services in SQL Server
  • Select all date between which an object has certain properties
  • Why does LEN( char(32) ) = 0 in T-SQL?
  • To split records in one column into multiple columns
  • Select cities from table, which do not start with vowels and do not end with vowels
  • Call stored procedure for each row from select
  • Inner Join Query with 2 tables giving different result compared to Sub Query for same 2 tables Northwind database
  • After a specific time of day - which method is better?
  • SQL Server: link DB2 table
  • Error copying SQL Server database from one server to another
  • Need to calculate the sum of second using a function from a string variable using SQL
  • How to convert from DD/mm/yyyy in varchar(max) to yyyymmdd format in SQL Server
  • How to remove only certain items within a column that has multiple words listed in cell
  • Partition or Index large table in SQL Server
  • Switch CASE in stored procedure in SQL
  • VS 2019 SSIS package can't add SQL Server
  • Combine two Column into One column with out union
  • is there a way to update multiple row using one update query?
  • How to we prevent SQL Injection by Regular Expression or any other way in asp.net
  • What does # after a column name mean in SQL Server
  • Using SSIS and T-SQL to convert date to dd.mm.yyyy
  • Stored procedure from VBA Excel not running
  • Stored procedure with dynamic SQL and ORDER BY
  • Join two tables in SQL Server
  • SQL Server substring(substring())
  • Msg 209, Level 16, State 1, Line 4 Ambiguous column name 'DonorID'. Msg 209, Level 16, State 1, Line 1 Ambiguous column
  • CASE WHEN Formula in SQL
  • T-SQL Issue using lead or lag
  • ALTER TABLE my_table ADD @column INT
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com