What exactly an index is?
An oracle Index is just like the index we see at the end of each book, which is an alphabetically sorted list of topics, along with the page numbers which tells where they are in the book. Similarly, an Oracle index stores the sorted list of indexed column, along with their rowid. Rowid tells the physical address of the row.
What is an explain plan?
An explain plan is a representation of the access path that is taken when a query is executed within Oracle.
At the physical level Oracle reads blocks of data. The smallest amount of data read is a single Oracle block.
Logically Oracle finds the data to read by using the following methods:
Full Table Scan (FTS)
Index Lookup (unique & non-unique)
Rowid
Enjoy:-)
2 comments:
zhengjx20160428
louis vuitton handbags
air jordan shoes
concord 11
michael kors handbags
toms
beats by dr dre
tods outlet store
nhl jerseys
oakley vault
louis vuitton outlet online
adidas originals
coach outlet
christian louboutin shoes
retro 11
ralph lauren polo
michael kors outlet
christian louboutin shoes
ladies cartier watches
coach factory outlet
louis vuitton
ralph lauren
jordan retro 13
vans sneakers
louis vuitton handbags
coach outlet
air jordan 4
air jordan shoes
ralph lauren home
louis vuitton purses
nike running shoes for men
gucci belts
coach outlet online
ray ban sunglasses outlet
nike uk
pandora jewelry
true religion jeans
louis vuitton outlet
michael kors outlet
celine bags
michael kors outlet clearance
zzzzz2018.8.31
nike requin
nike soldes femme
moncler outlet
ralph lauren outlet
canada goose jackets
canada goose outlet
canada goose outlet
moncler online
nike air max
pandora
Post a Comment