Does a set of best practices exist in regards to indexing?

 

Example:

To help conserve resources, should indexing be removed once used?

 

Can indexes become corrupted?  If so, is there a method to determine the
corruption and correct?

 

In some situations, can an index save memory?  For instances, rather than
conducting a full scan on a very large file to return data (which would
require loading the file into memory), can using index prevent the full file
load?

 

Sorry, I am not a dba type, so I am unaware of the problem space and
techniques used in db development.  I reviewed the Sedna technology papers,
but I am still clueless.

 

Thanks,

Malcolm

------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security 
threats, fraudulent activity, and more. Splunk takes this data and makes 
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Reply via email to