Interested to Buy Any Domain ? << Click Here >> for more details...
Query processing is slow(eg select query)how will u solve that
- 3 Answers
- 7920 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jayesh
WE CREATE PROCEDURE THEN ACCESS IT
INDEXING ALSO DONE
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / mohapatra.gouranga@gmail.com
1) Find the cost.
2) Check what tables are going full table scan.
3) Create Indexes if is possible.
4) Re-write the query to optimize the cost with modifying
filter condition.
| Is This Answer Correct ? | 0 Yes | 0 No |
What types of replication are supported in sql server? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the commands used in dcl? : sql server DBA
How do you add a data file to a tablespace?
why Datapump is faster than traditional export and import
Oracle 11g new features?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How would you determine who has added a row to a table?
what is the differnce between process and thread ?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
What is blocking and how would you troubleshoot it?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
-
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)
