1. How actually index will work ?
2. Why do people prefer mostly bitmap index and btree index
in datawarehouse ?
3. If I use the column in aggrigate functions like
max,min,count and avg and if I have a index created on that
column, will it increases the performance ?
Answer / mrs.priya
1.index file created separately(uses separate memory) apart
from the original file to increase performance
2. good performance
3. yes it increases the performance because index uses
separate memory
Is This Answer Correct ? | 3 Yes | 0 No |
What is a OUTER JOIN?
What is the use of aggregate functions in oracle?
Give the constructs of a package, function or a procedure.
How can I get column names from a table in oracle?
Can sub procedure/function be called recursively?
What is oracle instant client?
What is the difference between sharding and partitioning?
what are the advantages of running a database in NO archive log mode?
What are the composite date types in oracle?
What is blob data type in oracle?
how to insert the image in table
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.