WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
- 4 Answers
- 7462 Views
- CTS, iNautix, TCS, I also Faced
- E-Mail Answers
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
What is field in database give an example?
What is the Structural difference between bitmap and b-tree index ?
Explain the classification of Database Management System?
What do you understand by ‘database’?
What are database modules?
What is database write application of database?
Mention a query to calculate the even and odd records from a table
What is network database?
What do you understand by intension and extension?
What is the rdbms concept in sql?
Define ddl and dml.
Explain the advantages and disadvantages of a hierarchical database?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
Explain data independence?
What are stored-procedures? And what are the advantages of using them.
