GeekInterview.com
Series: Subject: Topic:
Question: 1 of 7

Tuning SQL Query

In 10g Linux platform, today i executed a query which takes 5 minutes to execute. I executed the same query the next day it took long time to execute, what will be the problem?how to identify it?tel me the solutions also.
Asked by: Interview Candidate | Asked on: Sep 16th, 2011
Showing Answers 1 - 1 of 1 Answers
navin amarasiri

Answered On : Jul 6th, 2012

Try some indexing...

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Backup and Recovery

Basics

Concepts and Architecture

D2K

Data Access

Database Administration

Database security

Database Tuning

Distributed Processing

General

Memory Management

Oracle Forms 4.0

PL/SQL

Programmatic Constructs

RMAN Interview Questions

Scenarios

SQL

SQL Plus

System Architecture

Interview Coaching

Tell me about a skill you recently acquired or improved.

Does a problem make you a better person?

What do you think about our company?

Do you have any questions that you want to ask?

What are the things you wish to achieve in 5 years?

How do you handle conflict?

Has anyone asked you for help? What did you do?

Careers and Higher Education Options for BBA Graduates

Aptitude Test Preparation Tips

Has there been a time when you were presented a problem and solved it?

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe