Query processing is slow(eg select query)how will u solve that
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 |
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
What is a correlated sub-query? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
How would you determine the time zone under which a database was operating?
Which environment variables are absolutely critical in order to run the OUI?
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
What is the difference between online backup & offline backup?
how can you connect from 10g user to 11g user??
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
When creating a user, what permissions must you grant to allow them to connect to the database?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA