indexing

What do I miss in understanding the clustered index?

In absence of any index the table rows are accessed through IAM ((Index Allocation Map). Can I directly access a row programmatically using IAM? Does absence of index mean that the only way to read specific row is full table scan reading all table? Why IAM cannot be engaged for more specific direct access? "If the table is a hea...

noindex no follow variable- have I done this correct?

I have this script in the head of all my pages- which in an include: <?php if (isset($robots) && $robots == "off") { $robots = '<meta name="robots" content="noindex,nofollow">'; print $robots."\n"; } else { $robots = '<meta name="robots" content="index,follow">'; print $robots."\n"; } ?> After the hea...

Best practice for ensuring Solr/Lucene index is "up to date" after long rebuild

Hi all, We have a general question about best practice/programming during a long index rebuild. This question is not "solr specific" could just as well apply to raw Lucene or any other similar indexing tool/library/black box. The question What is the best practice for ensuring Solr/Lucene index is "absolutely up to date" after long i...

Why to add clustered index keys to all (intermediate) nodes on NCI?

Considering clustered table, Quassnoi wrote (the last phrase in answer): If the secondary index is declared UNIQUE, clustered key is appended only to the leaf-level records of the secondary index. This sounds like clustered key is added to (all) indermediate nodes of non-unique non-clustered index. And by the same logic RIDs are a...

How sequential traversing between intermediate leaves of clustered index used?

Intermediate leaves of clustered index are linked sequentially (next, previous) for faster access (between intermediate nodes) [2], [3], etc.: How this access is used? Why is it needed? [2] Clustered Index Structures http://msdn.microsoft.com/en-us/library/ms177443.aspx [3] Clustered Tables vs Heap Tables http://www.mssqltips.com/...

Index Stemming to process text in c sharp or ruby

Given this text: "Friends are friendlier friendlies that are friendly and classify the friendly classification class. Flowery flowers flow through following the flower flows" I need to apply stemming to the text to achieve the following outcome: frequency("following") = 1 frequency("flow") = 2 freque...

Can PostgreSQL index array columns?

I can't find a definite answer to this question in the documentation. If a column is an array type, will all the entered values be individually indexed? I created a simple table with 1 int[] column, and put a unique index on it. What I noticed is that I couldn't add the same array of ints, which leads me to believe the index is a compos...

How does MongoDB index arrays?

In MongoDB, if I were to store an array (say "red", "blue") in a field "color", does it index "red" and "blue" so I could query for "red", for example, or does in make {"red", "blue"} a composite index? ...

How to index a web site.

I'm asking on behalf of somebody, so I don't have too many details. What options are available for indexing site content in an ASP.NET web site? I suspect SQL Server's Full Text index may be used if the page content is stored in the database. How would I index dynamic and static content if that content isn't stored in the DB, but in ...