What rule optimizations are possible in SQL query tuning?

  • Interview Candidate
  • 3
  • 1509

Showing Answers 1 - 3 of 3 Answers

onkar

  • Sep 28th, 2005
 

for optimization of a sql query, u first need to check the bottleneck and then taste the query with CBO/RBO. Using the option which is best for ur environment. For CBO to work , u need to analyze the table first then only it will have some effect on the performance of the query.

  Was this answer useful?  Yes

Chiranjeevi Manne

  • Nov 9th, 2005
 

FIRST_ROWS

LAST_ROWS

FIRST_ROWS_10

FIRST_ROWS_100

FIRST_ROWS_1000

ALL_ROWS

  Was this answer useful?  Yes

habib

  • Nov 12th, 2005
 

send me questions about databases and certifications tools of databases oracle sqlserver please

  Was this answer useful?  Yes

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