types of indexes and the rationale behind choosing a
particular index for a situation.
No Answer is Posted For this Question
Be the First to Post Answer
how many types of index?
Difference between cartesian join and cross join?
what is main def between plsql/table and array?
Name the three major set of files on disk that compose a database in Oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is Network Database link ?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
Explain a data segment?
What is the parameter mode that can be passed to a procedure?
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 ?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
various types of hints and their usage