I was goin' through one of the blogs (forgot which one it was), but it mentioned that we can create virtual indexes. Basically, what it does is that -- it doesn't create the index physically, but acts as a index virtually.
Sometimes you might be wondering wether creating index on a certain column is goin' to decrease the cost of the execution plan. Then this might be of great help.
Will post the exact syntax next time. Just got reminded of it and wanted to mention it here.
-- Vish.
skip to main |
skip to sidebar
![](alt=" "Use
OpenOffice.org")
Just a way to keep myself and others posted regarding my old, new findings in ORACLE
No comments:
Post a Comment