Closed

SQL Query tuni ng

Hi, I need someone to optimize below SQL Query. This is run against a large database. The cross join hurts so do the CHARINDEX AND CONVERT.

SELECT * FROM bank_import AS A4

INNER JOIN

(

SELECT [url removed, login to view] AS ImportID, [url removed, login to view], substring([url removed, login to view], 1, 1) As Location, [url removed, login to view] AS BankArchived,

[url removed, login to view] AS EnrollID, [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view],

[url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view] AS StudentID

FROM students

INNER JOIN students_enroll ON [url removed, login to view] = [url removed, login to view]

CROSS JOIN bank_import

WHERE (((CHARINDEX(CONVERT (VARCHAR, [url removed, login to view]),[url removed, login to view]) > 0))

AND ((CHARINDEX(CONVERT (VARCHAR, [url removed, login to view]),[url removed, login to view]) > 0)) OR ((CHARINDEX(CONVERT (VARCHAR, [url removed, login to view]), [url removed, login to view]) > 0)))

AND bank_import.IsArchived=0 AND (students_enroll.CycleID=19 OR students_enroll.CycleID=18)

)

As A5 ON [url removed, login to view] = [url removed, login to view] WHERE A4.MatchFound=0 AND A4.DateReleve='2014-01-29'

Skills: SQL

See more: substring c, c substring, Sql query, motif, sql optimize, convert sql database, tariff database, natural language query sql software, query optimize, tariff, natural language query sql query, location sql database, convert sql query sql query, convert sql query sql, substring, convert natural language query sql, need sql query, natural language query sql, sql optimize database, sql query sql query, convert a4 a5, a4 convert a5, postcode sql, sql query database, uusing data adaptor aspnet query sql server database

About the Employer:
( 30 reviews ) Theux, Belgium

Project ID: #5375971

28 freelancers are bidding on average $35 for this job

elboukharimu

Hi, I'm very interested helping you optimizing your query, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfoli More

$30 USD in 1 day
(16 Reviews)
4.6
angan

I can do it. please give me sample data with table schema. I can help it.................................

$20 USD in 1 day
(19 Reviews)
4.4
schungur

DATABASE EXPERT... PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS and ensure yourself that I can do this very well and very quick... Please note on SQL Level3 badge... there are only 4 on Freelancer... The subquery in yo More

$35 USD in 3 days
(4 Reviews)
4.1
danale72

Hi I need execution plan and indexes of the all tables in the query It would be great to get verbal description what the query should to to rewrite some parts. Al More

$55 USD in 1 day
(13 Reviews)
4.1
NourElDeen

Dear Sir, I'm expert at sql, and i'm interested on helping you,could you please send me a small backup from your database? Kind Regards, NourElDeen

$30 USD in 1 day
(23 Reviews)
3.9
vhrios

Hi!, Ican help you to optimize your query. I'm a SQL Server expert with 10+ years of experience. Thanks in adavance!

$35 USD in 1 day
(3 Reviews)
3.5
DeoTech

Hello, I have more than 13 years experience in MS SQL. Can you provide MS SQL database? I can help you in your project. Regards

$35 USD in 3 days
(5 Reviews)
3.6
codetod

Hi Loctrans I can see that this is a poorly constructed SQL. RDBMS supports cross join theoritically but practically we need to apply cross join in very rare scenarios. Also I can see the condition CHARINDEX(CONVERT More

$45 USD in 5 days
(7 Reviews)
2.8
acer2004sl

Hello, I'm ready to improve that. if you have a phpMyAdmin, it will be perfect if you can provide that for testing the speed, and the enhancement Thank you

$44 USD in 0 days
(4 Reviews)
2.6
Champian

Hi, What is the current execution time of the query ? Can you please provide your db access so I can have a look at the db structure. I am working as a freelancer website designer and developer, I have 5+ years More

$34 USD in 3 days
(2 Reviews)
1.7
salescloudester

Hello, I have 5+ years of experience in bulk data processing in mysql,mssql and oracle. I can try. skypeid-cloudester Thank You, Ronak

$55 USD in 1 day
(1 Review)
1.4
abdellatif81

Hello, Interested by your project i would like to inform you that i am IT engineer , having more than 7 years in IT projects with 5 years in database development and tuning in SQL Server databases all versions. More

$25 USD in 1 day
(1 Review)
0.6
hellomahesh

Here you go for free.. HTH SELECT * FROM bank_import AS A4 INNER JOIN (SELECT bank_import.ID AS ImportID, bank_import.Motif, SUBSTRING(bank_import.Motif, 1, 1) AS Location, bank_import.IsArchived AS BankAr More

$10 USD in 1 day
(0 Reviews)
0.0
karouiachraf

Hi, I have more than 7 years experience in data analysis please contact me and I will optimize your query on adding indexes to your table. Best Regards, Achraf Karoui

$15 USD in 3 days
(0 Reviews)
0.0
alexsanda

Hello, The optimization is as good as done. I have experience in SQL reporting in the largest bank in Romania (BCR - member of Erste Group), working with millions of daily transactions.

$25 USD in 1 day
(0 Reviews)
0.0
alxkris

Hi, I have 4 years experience with SQL and query tunning and I'm capable to provide the best solution for this problem. Best regards, alxkris

$25 USD in 1 day
(0 Reviews)
0.0
bboyina

A proposal has not yet been provided

$45 USD in 1 day
(0 Reviews)
0.0
nyingale

I have good experience on working on performance tuning. I have been working on this since past 6+ Years

$25 USD in 2 days
(0 Reviews)
0.0
KANZENSOFTWARES

Hello,Please provide me your database structure with some sample data records,i will optimize your query as per your requirement.Thanking you

$10 USD in 1 day
(0 Reviews)
0.0
Unni1988

Hello, This is Unnikrishnan and i am having 5 years of experience in SQL Development. I was working with a department which is specific to only database developers in a company named Cognizant,a multi national CMMI le More

$27 USD in 1 day
(0 Reviews)
0.0