Answer / priya sahoo

create index on table.

Answer / priya sahoo

create index on the table so that query retrival is faster

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.

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.

What is database management system with example?

0 Answers  

---

what the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?

3 Answers   Citrix, SAP Labs,

---

What are the steps involved in Database Startup ?

2 Answers   247Customer,

---

wHAT IS THE difference between foreign key and reference key

1 Answers  

---

Explain the terms database and dbms?

0 Answers  

---

What are the applications of rdbms?

0 Answers  

---

How do you maintain a database?

0 Answers  

---

Is it possible to determine clients ip address?

0 Answers  

---

Explain armstrong rules? How they are complete and/or sound?

0 Answers  

---

How to unzip a file in ssis?

0 Answers  

---

How can we tune if buffer busy wait issue comes in oracle?

1 Answers   IBM,

---

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

0 Answers   Wipro,

---