how to know whether index is rebuilt or not?

[confident]

i faced the interview for junior dba position, the interview ask me this quesiton

1.how to know the whether particular index is rebuilt or not and size of index. and how to know to what type of index it was..

2. user running a sql queries, by his queries, how to know, whether his queries using index or not...and what type index is using.... i replied to this answer, through explain plan we can know... is it right? if it right, please tell me, how to know from explain plain..

if u have any performance tunning interview question please forward to this mail id ..i will be very grate ful to him..

[engiri]

go through the dictionary views
Instead of going thorugh the interview questions you can
use documentations and testings.

[stmontgo]

Originally posted by engiri
go through the dictionary views
Instead of going thorugh the interview questions you can
use documentations and testings.

sigh

[OracleDoc]

It seems all roads lead to DB on Toms web page lol. It's funny how a discussion on index rebuilding leads to DB's escapades.

[KenEwald]

Dood, read the concepts guide. The answer is between page 17 and 383.

I like Tom Kyte. He is fact and example driven, a true "prove it" person. A true "DML Dictator".

Don't tell anyone, but he's actually a robot.