Tamamlanmış

DBA Expert

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, ',')))

Beceriler: SQL, Veri Tabanı Yönetimi, Veritabanı Geliştirme, Veritabanı Programlama, MySQL

Daha fazlasını gör: can improve performance job, improve performance php large project, photo shop expert need, filemaker expert need know, improve performance flv movie, improve performance website, improve performance prestashop, programmer need improve, xoops expert need, expert need promote ebay listing google adword, sql expert need, improve performance titanium app, excel expert need simple solution, joomla expert need, i just need someone to love me when it's hard to, how to improve performance of update query in oracle

İşveren Hakkında:
( 9 değerlendirme ) Mumbai, India

Proje NO: #31925756

Seçilen:

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 wo Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 1500%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)
0.6

Bu iş için 7 freelancer ortalamada ₹5614 teklif veriyor

(48 Değerlendirme)
5.6
ArturNasonov

Hello, Dear client! I've just read your description and guarantee to complete perfectly your job. I have 10+ years experience in the fields such as your requirement. You will get a good result after hiring me. My main Daha Fazla

₹7500 INR in 7 gün içinde
(2 Değerlendirme)
2.8
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 propos Daha Fazla

₹9800 INR in 7 gün içinde
(1 Yorum)
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

₹1500 INR in 3 gün içinde
(2 Değerlendirme)
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 Daha Fazla

₹1500 INR in 4 gün içinde
(1 Yorum)
0.8
(0 Değerlendirme)
0.0