Purchase Solution

Oracle9i Database SQL Search Query Optimization

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Summary

The expert examines Oracle9i Database search query optimization.

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 ...

Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Networking Questions

This quiz consists of some basic networking questions.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

C# variables and classes

This quiz contains questions about C# classes and variables.

View More Free Quizzes
Related BrainMass Solutions

  • Problems Involving Oracle9i Database

    ALTER DATABASE DATAFILE HANDS_62 OFFLINE DROP; This solution involves problems with the Oracle9i database.

  • Oracle9i Database

    Oracle9i Database is examined.

  • Oracle9i Database

    95134 Oracle9i Database 8. Give every employee in the Local Locale Company the privileges needed to query and update the NEWS_ARTICLE table and the CLASSIFIED_AD table. Write only two commands to accomplish this task.

  • Transaction Processing and Query Optimization

    This solution deals with transaction processing and query optimization. It also answers several questions related to query optimization, data replication and data fragmentation with well explained examples.

  • Subquery vs. Join.

    Communicate with a relational database to create tables, and query and manipulate data. Use normalizing and data integrity methodologies when designing a database.

  • Distributed Database Architecture

    Thus it is a more complex operation than query optimization in centralized databases. Query optimization overview Query optimization is essential if a DBMS is to achieve acceptable performance and efficiency.

  • Limits on the Average Database User

    -Administer Database Trigger (database level trigger) Administer Resource Manager Administer Any SQL Tuning Set Administer SQL Tuning Set Grant Any Object Privilege Grant Any Privilege Grant Any Role all_sys_privs dba_sys_privs session_privs

  • SQL Accounting Database

    The solution includes an SQL database containing the fields in the current Chart of Accounts, plus a "balance" field, an SQL query that will display all of the database fields, a test of the database by means of a query by account number and a report

  • SQL QUERIES

    Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection (use zip codes to restrict data). 5. Write a SQL query that uses UNION of the two tables to produce a third table.

View More Related Solutions