WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.

Answer Posted / deepak soni

if you talk about sql you should create clusterd index
but in oracle you have to create indexes to improve the
performance of query or you can say retrive the data in
faster rate.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How big is google's database?

488


What are the different stages in 'data warehousing'?

473


How do you create a simple database?

519


What's the best database software for mac?

490


What are the characteristics of dbms?

509






How do I create a database in open office?

513


What is the first step in creating a database?

484


What is field record and table in database?

478


What is progress apama?

546


What are the three types of databases?

478


What is distributed queries?

529


Write a query to create a duplicate table with and without data present?

460


What are the two types of data independence?

551


What do you mean by query evaluation engine?

528


What is entity relationship diagram?

495