DBA Expert

₹1500-12500 INR

I përfunduar

Postuar

over 2 years ago

₹1500-12500 INR

Paguhet në dorëzim

Need to improve performance in existing DB Query It's one sample of query it taking approx 1minute of time SELECT DISTINCT QuestionNatureID,QuestionNatureName,QuestionNatureCode FROM dbo.VW_SuggestedQuestionsFilter WHERE (@QuestionNaturelist = '00000000-0000-0000-0000-000000000000' OR QuestionNatureID IS NULL OR EXISTS (SELECT 1 from #QuestionNatureID where #QuestionNatureID.ID= QuestionNatureID)) AND (@DifficultyLevellist = '00000000-0000-0000-0000-000000000000' OR EXISTS (SELECT 1 from #DifficultyLevelID where #DifficultyLevelID.ID= DifficultyLevelID)) AND (@BloomTaxonomylist = '00000000-0000-0000-0000-000000000000' OR EXISTS (SELECT 1 from #BloomTaxonomyID where #BloomTaxonomyID.ID= BloomTaxonomyID)) AND (@QuestionLengthlist = '00000000-0000-0000-0000-000000000000' OR EXISTS (SELECT 1 from #QuestionLengthID where #QuestionLengthID.ID= QuestionLengthID)) AND ( TextBookChapterId in ( SELECT ChapterID FROM EA_PaperChapterMapping WHERE EAPaperTemplateid=@EAPaperTemplateid) OR ChapterID in ( SELECT ChapterID FROM EA_PaperChapterMapping WHERE EAPaperTemplateid=@EAPaperTemplateid) ) AND (@Marklist='' OR QuestionMark IN (SELECT CAST(Item AS int) FROM [login to view URL](@Marklist, ',')))

SQL

Database Administration

Database Development

Database Programming

MySQL

ID e Projektit: 31925756

Rreth projektit

7 propozime

Projekt në distancë

Aktive 3 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

I dhënë për:

@GAJERADPG

Dear Sir, Greeting of the day!!! My name is Dharmesh Gajera and I am an expert in SQL. I have more than 8 years of experience in SQL. I would love to have the opportunity to discuss your project with you. I have worked on the below projects: 1) More than 300 lines of Store procedure code which is calculating consumption. 2) Prepared a store procedure to find domain names from email addresses. In response to your task: 1) I have expertise in SQL and I can start work right now. 2) You only need to pay me if I am able to complete the project. 3) I can improve the query but I need to check the existing sample data as well. So, we can finish the project ASAP. Thank you for your time and consideration. Waiting for your reply. Thanks & Regards Dharmesh Gajera

₹1 500 INR në 3 ditë

5,0

(1 review)

0,6

7 profesionistët e pavarur ofrojnë mesatarisht ₹5 614 INR oferta për këtë punë

@caseypaite

Kindly contact me with details about the size of your table, information on which fields of your table are indexed and database server configuration. I may be able to help you out with your query optimization or propose a table optimization solution. The slow query could simply be a result of improper indexing.

₹9 800 INR në 7 ditë

5,0

(1 review)

1,4

@marchant2651

Hello, I would be happy to help with optimizing your query. I work with SQL on a daily basis and feel I can help with your problem. Let me know in the chat and we can further discuss this. Thank you

₹1 500 INR në 3 ditë

5,0

(2 përshtypje)

1,1

@MsFreedom911

Hello, I am Srajan and I have 5+ years of experience in C++,PostgreSQL programming and Software Development. I have your job description and I am sure I can work on it. You only need to pay me if you are satisfied with the work. Let's discuss more in the chat. Thanks Srajan

₹1 500 INR në 4 ditë