Our production database needs daily index defragmentation on one of its tables. The table has several indexes and one of them will get to 90% fragmentation each day. The index is on two date fields ( a start time and an end time). We do not get this problem on our development database although this obviously has a much lower throughput...
Test[] array = new Test[3]; array[0] = new RowBoat("Wood", "Oars", 10); array[1] = new PowerBoat("Fiberglass", "Outboard", 35); array[2] = new SailBoat("Composite", "Sail", 40); I have the above array and I need to display the results to a swing GUI with a next button that will display the first index values, and when ...
Hi, i have a table containing 15+ million records in oracle. its sort of a log table which has a created_ts column of type "date" . i have a simple "non-unique" type index on created_ts column. i have a simple range query : select * from table1 where created_ts >= ? and created_ts <= ?; when i run this query from SQLPlus or SQ...
I'm using indexPath.row do determine in which row of my tableview I do something. The title of my cells is containing a number which should be 1 in the first row and 18 in the last row, so I have 18 rows. This works for the first 11 rows, but after that, I have numbers in the title which seem to be generated randomly! Sometimes 16, then ...
We use a fairly straightforward naming standard for indexes that I can validate programmatically, but I am struggling with naming indexes with INCLUDE columns. If I do it based on a simple formula, it's too easy to build names that are too long. Then my programmatic validation fails, and I end up with truncated names. For those of you u...
I have an asp.net page, i want to change the active index numerical values to text values? like......... currently it is 1 to 2 and it goes like increasing............ instead ..i want a,b,c,d ............ ...
Hello, How can i make the selected link from the List below, bold, that you see you are on Page ex. 3 or 5 With this code if you click on a Link you dont know on which page you are. The smarty code looks like this; {section name="sitelinks" start=0 loop=$total->sitelinks} <span class='tag'> <a href='/member/{$campaign->id}?start={$...
The method or operation is not permitted. I assume this is a permission's issue, but I can't figure out where I would change it. It is strange because I can rename an index with no issue. EDIT: If you're looking at a table, and you see "Columns, Keys, Constraints, etc.", this is under Keys, and it is the system name that I presu...
Edit: This may be a 5.0-specific bug. (I'm on 5.0.83). Removing the innodb_log_file_size setting gets rid of the problem. Which makes complete sense. Not. Googling about finds a handful of similar, but not identical problems in 5.0 that were patched later. With the "wrong" settings in my.cnf, this create statement on MySQL 5.0 will...
I'm working on a small project in QT (well, pyQT4 actually, but it shouldn't matter too much) and I've run into the following problem. I have a QTableView with several rows and columns. I have set the selection mode to be rows only. When I call getSelectedIndexes() on my QTableView, I get an index for every row and column, which in the c...
I have this table: create table demo ( key number(10) not null, type varchar2(3) not null, state varchar2(16) not null, ... lots more columns ... ) and this index: create index demo_x04 on demo(key, type, state); When I run this query select * from demo where key = 1 and type = '003' and state = 'NEW' EXPLAIN PLA...
I have a site currently live on a domain. I would like to switch it to a new site, that is currently in a password protected sub directory on this server. I have a "Site Maintenance in Progress" page. I want to set Apache so it displays that by default instead of "index.php". Also, I'd like everything else on the server to be password p...
I just heard that you should create an index on any column you're joining or querying on. If the criterion is this simple, why can't databases automatically create the indexes they need? ...
I have created a recursive template for getting the first n number of items from my XML. It uses an index(counter) just like how I would in a for loop. Now how can I get a node from my XML using the index? I have tried [position()=$index] but it had weird behaviour when trying to get deeper nodes in the XML hierarchy. If I have XML su...
How to use index in a select query in oracle? When creating indexes can enhance performance? How to use indexed explicitly? ...
I am new to rails so go easy. I have developed my blog and deployed it successfully. The entire app is based out of the post_controller. I am wondering how I can reroute the users path to default to the post_controller vs. the app controller. To illustrate, if you go to http://mylifebattlecry.heroku.com you will see the default rails p...
i searched the docs and couldnt find it :( let's say i'm selecting all elements like: var items = $(".myClass"); it returns eg. 5 items - now how can i grab select eg. the 2nd one? items(2) or items[2] doesnt work .. ...
I need to reset my table counter back to 0 - is there a MySQL command for this? ...
i need a query to see if a table already has any indexes on it. ...
Currently we are interfacing our application with SAP. We are having a lot of performance problems with bapi/rfc approach. So recently we are trying "direct sql" approach to retrieve some data from SAP. Unfortunately, we've found that some of SAP table does not equipped with proper indices for our scenario. We've tried creating index w...