When composite index would be used by Oracle (SQL PLSQL Tricky Interview Questions)

[@swamivivekananda-cyclonicm8781]

Excellent.

[@pr-rb6jl]

Excellent

[@mandlanaresh]

Well explained...I was asked this question recently in an interview...

[@deepusasidharan2012]

Pretty good

[@gaurichaudhari9310]

Very well explained with example. Thank you so much for making this video.

[@ankursrivastava4164]

Hello Sir, Any reason behind that we keep the column in same order as it defined in composite index ?

[@trickyinterviewquestions]

Column sequence in table can be in any sequence. Only thing is select query where clause and composite index columns should match

[@chaochen2758]

Good explanation! Could you help me? How to drop a composite index in oracle?

[@trickyinterviewquestions]

Same process which you follow to drop any index.

[@priyankasarkar6600]

Nice one.. Thank you sir! I have one question- if you have 1million distinct records in a table, then for performance tuning which index is good? btree index?

[@trickyinterviewquestions]

Yes. when we store employee ids or any other ids... we create bteee index.... because those ids are mostly distinct... hence btree should be created.