Hello Siva, Below are related to Index. Please let me know the answers 1. Online index rebuild and locking 2. Differences between online and standard index rebuild 3. What does it mean in Index 3.1 rebuild online parallel 63 nologging 3.2. noparallel,logging Regards, Ranaj Parida.
Q) In Employee table we have column in that we are going insert the gender data like male, female, other. Which index we can use? And how to decide this index right for this column ?
What is "index clustering factor" ? select one or more relevant answer it shows the rate of index fragmentation , it's a metric relevant to the keys spread in index, it relates to the data organization in table, it is the number of keys used in indexed table cluster
Please give link while refer another videos which posted by you. I have really confused and tired while searching index related videos.....it would be very help for new comers 😊
in general, you can say about bree, bitmap, function and reverse key index, if interview specifically ask for clustered, local and global index, then you can explain the same
Good explanation 👍.But in my query having indexes in where clause of cloumns all and I am not using any function based indexes but it will choose full table scan ? Can u explain why ?
Very clear and perfect explanation. So mean while request you to share the videos related to performance tuning in real time with explain plan interpretation. And also the DB architecture
Can we create different type of index on the column have indexes already . Ex: eno have btree and i try to create bitmap with eno,ename is it possible.. in this case Oracle which index will pickup primary as btree or bitmap
ya Manoj, Its diff to cover all the questions in single video, thats the reason, I am splitting to multiple videos, all the questions will be covered in upcoming videos