Explore BrainMass
Share

Explore BrainMass

    Oracle9i Database SQL Search Query Optimization

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    The newspaper had added a special deal for the classified ads online. For a small fee, the words "BEST BUY" are added to the text of the ad, and these ads are listed on a special "Best Buy" page online. The online classified section has a query to bring up all the ads that qualify, but it runs very slowly. Here is the query.

    SELECT AD_TEXT, AD_NO
    FROM CLASSMATE.CLASSIFIED_AD
    WHERE INSTR(AD_TEXT, 'BEST BUY') > 0

    Create an index that will be used for this query and therefore speed up its response time. Save your SQL in a file.

    © BrainMass Inc. brainmass.com October 9, 2019, 6:38 pm ad1c9bdddf
    https://brainmass.com/computer-science/files/oracle9i-database-sql-search-query-optimization-93615

    Attachments

    Solution Preview

    Please see the attached files.

    The newspaper had added a special deal for the classified ads online. For a small fee, the words "BEST BUY" are added to the text ...

    Solution Summary

    The expert examines Oracle9i Database search query optimization.

    $2.19