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

What are databases what are the uses of databases?

455


What do you understand by ‘database’?

545


How many database systems are there?

485


What's difference between dbms and rdbms ?

554


What is tabular form?

537






What are the advantages and disadvantages of views in the database?

645


What is db flush?

480


how to restore particular schema from rman full backup?

1300


What versions of clipper does netlib support?

497


What are the types of tables in database?

481


Explain the advantages and disadvantages of a hierarchical database?

598


what are the acid properties in dbms?

527


when All datafiles related to a Tablespace are removed ?

1505


What is the meaning of flat file database?

475


What is dbms introduction?

489