Assume a MySQL MyISAM table with one gigabyte of data and one gigabyte of indexes. Furthermore, assume that during development columns and indexes will be added and removed from/to the table quite frequently. Due to the size of the database the column/index creation is slow when using the standard non-tuned MySQL settings. Which MySQL ...
This is in C. I have two 2D arrays, ArrayA and ArrayB, that sample the same space. B samples a different attribute than ArrayA less frequently than ArrayA, so it is smaller than A. Just to try to define some variables: ArrayA: SizeAX by SizeAY, indexed by indexA for a position posAX, posAY ArrayB: SizeBX by SizeAY, indexed by indexB...
Is there any benefit to running an UPDATE Statistics after you create an index or is it done automatically for you? ...
When creating an index for a specific query is it good practice to index all columns that are in the where clause and then have any columns selected in the "included columns" section? Should I leave bit columns out of the index? ...
Our application allows a user to enter company names that their organization works with. A current issue is that the way one user inputs the company name varies from user to user. We need to consolidate this data. Are there any proven approaches for tackling this problem? ...
Hi I was just working on a web application and find that the most the mysql tables have fields, like, is_live, can_do, required, published (and many more) having field type TINYINT, and takes either 0 or 1 only. I was just wondering if I need to create indexes on these columns as scripts are using joins which include these columns as w...
Does the following seem normal for a histogram on an index? Histogram Steps RANGE_HI_KEY RANGE_ROWS EQ_ROWS DISTINCT_RANGE_ROWS AVG_RANGE_ROWS 2264548 0 1 0 1 2302473 36550 1 36550 1 2303523 767 1 767 1 2383218 77051 1...
If you're doing min/max/avg queries, do you prefer to use aggregation tables or simply query across a range of rows in the raw table? This is obviously a very open-ended question and there's no one right answer, so I'm just looking for people's general suggestions. Assume that the raw data table consists of a timestamp, a numeric foreig...
Let's say I have an ASP.NET web application. I create an aspx page that shows a table containing users and email addresses. The user data is stored in a database, and when the page is requested by a logged-in user, html is generated to display the data. If the users requesting the page are not logged in, they are redirected to a sign-in ...
Three months ago I published my small personal website (~10 pages), submitted the URL to Google, and a few days later Googlebot showed up. Over the course of the last couple of weeks, Googlebot visits my website approximately twice a week and crawls maybe every other page. Ever since Googlebot first crawled my website, whenever I run a...
I'm looking for ways to prevent indexing of parts of a page. Specifically, comments on a page, since they weigh up entries a lot based on what users have written. This makes a Google search on the page return lots of irrelevant pages. Here are the options I'm considering so far: 1) Load comments using JavaScript to prevent search engin...
I'm using Mysql 5.0 and am a bit new to indexes. Which of the following queries can be helped by indexing and which index should I create? (Don't assume either table to have unique values. This isn't homework, its just some examples I made up to try and get my head around indexing.) Query1: Select a.*, b.* From a Left Join b on b.type...
if we use the ALTER TABLE RENAME PARTITION statement to rename the existing partitions in an Oracle table, do we need to recreate the local partitioned indexes with newly changed partition names? ...
Hi experts,,, I have a pdf document with content in Arabic language and when I try to search inside the document for a specific word, adobe reader returns no results. it seems a format problem... how can I fix that? thanks. ...
I have a database full of phrases (80-100 characters), and some longish documents (50-100Kb), and I would like a ranked list of phrases for a given document; rather than the usual output of a search engine, list of documents for a given phrase. I've used MYSQL fulltext indexing before, and looked into lucene, but never used it. They bot...
According to TkDocs: The "1.0" here represents where to insert the text, and can be read as "line 1, character 0". This refers to the first character of the first line; for historical conventions related to how programmers normally refer to lines and characters, line numbers are 1-based, and character numbers are 0-based. I hadn't ...
I have a Sitecore content structure where any single item can have a number of child items that are used to store enumerable content for lists (obviously a fairly standard approach). I am hoping to index these items but store their index data against the parent doc in Lucene. This should hopefully speed up the search bit, by saving time ...
Simple question: does SQLite support FULL-TEXT searches? If not, is there any way I can implement that feature? ...
Hai guys, when to set index for a table (ie) during table creation or on performance tuning? What are the advantages and disadvantages of indexing? ...
Hi, I have around 3.5 million records in a particular table in Oracle 10g and I want to query for all records with one particular column having NULL value. My question is, is it worth to create an index on that column just for the purpose of that one query? Will the time saved by using the index compensate the time taken to create it? ...