WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.

Question Posted / bharath reddy

4 Answers
7137 Views
CTS, iNautix, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO...

Answer / priya sahoo

create index on table.

Is This Answer Correct ?

20 Yes

2 No

WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO...

Answer / priya sahoo

create index on the table so that query retrival is faster

Is This Answer Correct ?

18 Yes

2 No

WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO...

Answer / deepak soni

if you talk about sql you should create clusterd index
but in oracle you have to create indexes to improve the
performance of query or you can say retrive the data in
faster rate.

Is This Answer Correct ?

8 Yes

0 No

WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO...

Answer / muzaffar ali umrani

first check is there any index created in on that table, if yes then arrange your query according to index and check its execution plan and if there is no index on query then create the index.

Is This Answer Correct ?

7 Yes

0 No

Post New Answer

More Database Management Interview Questions

Define entity set.

0 Answers

What is the importance of query in database?

0 Answers

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

0 Answers

What are the types of Calculated columns available ?