Đã hoàn thành

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

Kĩ năng: SQL, Quản trị cơ sở dữ liệu, Phát triển cơ sở dữ liệu, Lập trình cơ sở dữ liệu, MySQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 9 nhận xét ) Mumbai, India

ID dự án: #31925756

Được trao cho:

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 Thêm

₹1500 INR trong 3 ngày
(1 Nhận xét)
0.6

7 freelancer chào giá trung bình₹5614 cho công việc này

(48 Nhận xét)
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 Thêm

₹7500 INR trong 7 ngày
(2 Nhận xét)
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 Thêm

₹9800 INR trong 7 ngày
(1 Nhận xét)
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 trong 3 ngày
(2 Nhận xét)
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 Thêm

₹1500 INR trong 4 ngày
(1 Nhận xét)
0.8
(0 Nhận xét)
0.0