Does indexing improve query performance?

Answer Posted / kiran r

Yes Index Improves performance of Query

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does seeding a database mean?

525


What is spool?

588


Explain the savepoint statement.

597


What are user defined functions?

577


Difference between table function and pipelined function?

583






Explain about various levels of constraint.

521


i have some prob lem to tell me about my self in interview first round ...

1700


How would you reference column values before and after you have inserted and deleted triggers?

620


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

545


What is pl sql block structure?

539


How do I find duplicates in the same column?

543


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

551


Can you do multiple joins in sql?

543


How do I remove duplicates in two columns?

508


How do I access sql anywhere database?

495