Answer / saravakumar

You can use index hint (index=index_name) after the table
name. SELECT au_lname FROM authors (index=aunmind)

What is microsoft sql server?

0 Answers  

---

What is cursors?

0 Answers   NA,

---

How do I start sql server agent automatically?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

Is oracle faster than sql server?

0 Answers  

---

---

Explain different forms of normalization?

0 Answers  

---

How do you rebuild an identity column?

0 Answers  

---

What does normalization do to data?

0 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

How to list all user names in a database?

0 Answers  

---