In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

what is query cache in mysql? : Sql dba

0 Answers  

---

how can you create an empty table from an existing table? : Sql dba

0 Answers  

---

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

---

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

---

can we create index on index?

7 Answers   iFlex, Symphony,

---

What is pl sql commands?

0 Answers  

---

When is the update_statistics command used?

0 Answers  

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

---

what is global variable in package

3 Answers   Polaris,

---

What is the difference between pl and sql?

0 Answers  

---