?url_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Adc&rft.title=Optimising+SQL+Queries+Using+Genetic+Improvement&rft.creator=Callan%2C+J&rft.creator=Petke%2C+J&rft.description=Structured+Query+Language+(SQL)+queries+are+ubiquitous+in+modern+software+engineering.+These+queries+can+be+costly+when+run+on+large+databases+with+many+entries+and+tables+to+consider.+We+propose+using+Genetic+Improvement+(GI)+to+explore+patches+for+these+queries%2C+with+the+aim+of+optimising+their+execution+time%2C+whilst+maintaining+the+functionality+of+the+program+in+which+they+are+utilised.+Specifically%2C+we+propose+three+ways+in+which+SQL+JOIN+statements+can+be+mutated+in+order+to+improve+performance.+We+also+discuss+the+requirements+of+software+being+improved+in+this+manner+and+the+potential+challenges+of+our+approach.&rft.publisher=IEEE&rft.date=2021-07-07&rft.type=Proceedings+paper&rft.publisher=The+10th+International+Workshop+on+Genetic+Improvement+%40+ICSE+2021&rft.language=eng&rft.source=+++++In%3A++2021+IEEE%2FACM+International+Workshop+on+Genetic+Improvement+(GI).++++IEEE+(2021)+++++&rft.format=text&rft.identifier=https%3A%2F%2Fdiscovery.ucl.ac.uk%2Fid%2Feprint%2F10122956%2F1%2Fmain.pdf&rft.identifier=https%3A%2F%2Fdiscovery.ucl.ac.uk%2Fid%2Feprint%2F10122956%2F&rft.rights=open