WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
Answers were Sorted based on User's Feedback
Answer / priya sahoo
create index on the table so that query retrival is faster
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / 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 |
Answer / muzaffar ali umrani
first check is there any index created in on that table, if yes then arrange your query according to index and check its execution plan and if there is no index on query then create the index.
| Is This Answer Correct ? | 7 Yes | 0 No |
wat is meant by oracle
How does notification services work?
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
Is filemaker pro a relational database?
what is GET_BLOCK property ?
what is difference between paging and fragmentation?
What is key dbms?
When does checkpoint occur?
Where is database used?
Can we linked SharePoint to a SQL databasebe?
0 Answers Sans Pareil IT Services,
Is it possible to Disable the Parameter form while running the report ?
What is inner join in database?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)