Search Result

Collapse
18 results in 0.0041 seconds.
Keywords
Members
Tags
index
  •  
  • Page of 2
Previous 1 2 template Next
  • Rabbit
    started a topic How To: Optimize SQL Queries
    in SQL Server

    How To: Optimize SQL Queries

    Introduction
    In this article, I discuss the basic methods I use to analyse and optimize SQL queries. A properly written SQL with appropriate indices can turn a query that runs in hours into one that runs in seconds. While the code in this article is rooted in SQL Server, most of the concepts will apply to other databases.

    We will go over:
    1. Analyzing Performance of Queries
    2. Optimizing SQL Syntax
    3. Query Execution Plans
    4. Creating
    ...
    See more | Go to post
    Last edited by Rabbit; Mar 13 '12, 05:19 AM.
    • Vikki McCormick
      started a topic Performance Improvement of Stored Procedure
      in SQL Server

      Performance Improvement of Stored Procedure

      I have a stored procedure which is being used on an online form.

      In the form the user is able to ask for records based on an Age. So 5 days old, 2 days old, etc. The age is based on the date that the record was entered or received. So we have JobReceiveDate.


      The stored procedure was written like this. Where @Ageto and @AgeFrom come from the online form.

      Code:
      JobReceivedDate Between DateAdd(dd,
      ...
      See more | Go to post
      • tharindu96
        started a topic 'Notice: Undefined index:' Error
        in PHP

        'Notice: Undefined index:' Error

        I'm getting a error message in php the file is attached.

        Notice: Undefined index: textbox in C:\wamp\www\mys ite\index.php on line 2

        Code:
        <?php
echo $text = $_POST['textbox'];
?>

<form action="index.php" method="post">
	<input type="text" name="textbox">
    <input type="submit" value="Submit">
        ...
        See more | Go to post
        Last edited by Niheel; Jan 25 '12, 09:45 PM. Reason: much easier if you post your question with all the details, your information was merged
        • Ahlam Hussain
          started a topic Retrieving the address of a record in a text file
          in C

          Retrieving the address of a record in a text file

          Good Morning every one;

          I'm attending to apply indexes concept using c++ text files.

          I need to create two text files, one for index, the other for data records.

          I should insert/delete records to the text file according to physical address of the line, not to the number of the line in the text file.

          My problem is to get the address of the line I need to insert/delete from.

          ...
          See more | Go to post
          • melaniejp
            started a topic Please advise a better index
            in Oracle

            Please advise a better index

            I created an index for a table but the performance increased just a little.
            What the problem is and how should I create the index?
            The SQL cannot be changed and only an index is required to increase the performance.

            The following is detailed enviorenment.
            (1)DB: Oracle10.2.0.3
            (2)SQL:
            select * from
            (SELECT col1,col2, col3, col4 FROM table1
            where col0 = 140 AND
            col2>=to_date(' 2011-08-30','YYYY-MM-DD')...
            See more | Go to post
            • Joe Farage
              started a topic manually updating text box causes primary key problems
              in Access

              manually updating text box causes primary key problems

              I have a form that has several subforms on it. They are all linked to the main table by use of a field called Patient ID.
              On this form, if I use the buttons for first record, previous record, next record, last record; there is no problem and everything works correctly.
              But if I try to type in an ID number in the box and then hit tab, it gives me the following dialog box.

              "The changes that you requested to the table...
              See more | Go to post
              • Christian Sve
                started a topic How to take content from file and put it into an array list?
                in C Sharp

                How to take content from file and put it into an array list?

                So I have got a problem, my program is not functioning as I want it to...

                I probably have a lot of errors in my code but what I want to do is that this code will take text from "latest.txt " (about five lines) and put it in a list. Later on, when this module is completed, my main program have a search function with a sort of "history of searches"(input ) and what I want is to make this module put the recent searched...
                See more | Go to post
                • Newb Mac
                  started a topic How does data indexing work in MS SQL?
                  in SQL Server

                  How does data indexing work in MS SQL?

                  I am newbie in MS SQL. Can anyone show me how indexing works in a database??
                  See more | Go to post
                  • Scott Evans
                    started a topic How to create full text searchability in PHP webadmin?
                    in MySQL

                    How to create full text searchability in PHP webadmin?

                    I am trying to create a full text search of my database but continue to get an error despite having indexed the TEXT columns (caption and location) under a single index (searches). How do I get the database to use full text searching?

                    A. I have added a SINGLE full text index on the two columns which are both of the TEXT type.

                    B. I have created a unique key using an image_id field(NOTE: none of the fields contain images;...
                    See more | Go to post
                    • jbrumbau
                      started a topic How do I get the index of a control for reference?
                      in Access

                      How do I get the index of a control for reference?

                      Hello,

                      I'm trying to obtain a form control's index. For example, a form may have 30 or so controls on it. To refer to control 15, I can do:
                      Code:
                      frm.Controls(15)
                      My goal is to populate a listbox with the indexes of all controls that have a tag, executing on Form_Load. Then, I wish to reference all controls in the listbox by index on Form_BeforeUpda te. I do this for change tracking in a form. Currently...
                      See more | Go to post
                      • Venkat Avinash
                        started a topic can i create a index using substric in DB2 9 ?
                        in DB2

                        can i create a index using substric in DB2 9 ?

                        Hi,

                        Is below Create Index DDL Valid?

                        Create index index_name on table_name (substr(col1,2, 3) ASC);
                        See more | Go to post
                        • mysticwater
                          started a topic Webmaster help!!
                          in HTML CSS

                          Webmaster help!!

                          Hi, I have submitted my site to google two months back. Its indexed in yahoo and bing. I created a webmaster account and added my site to it.
                          But the dashboard still shows "no data available" on all fields.
                          I submitted the full ur; (with http://) AND just the www BUT both still show no data available.
                          I have waited two months. Why is this occurring??
                          My site appears on google when i type the url but its not...
                          See more | Go to post
                          • Rickard Hill
                            started a topic Change combobox value
                            in C Sharp

                            Change combobox value

                            Fellow csharpers..

                            I got a problem that I haven't found a solution for, and are hoping to get some help.

                            I have the following piece of code (with commented out parts that I tried without success)
                            Hoping someone can help me.

                            Code:
                            else if (msg[0].ToString() == "set")
                    {
                        MessageBox.Show(msg[0].ToString());
                            ...
                            See more | Go to post
                            • adnankatmer
                              started a topic MySQL Substring Index Problem
                              in MySQL

                              MySQL Substring Index Problem

                              Hello,

                              As much as I understand, MySql does not support indexes on substring selects. I have need a query like:

                              Code:
                              					SELECT 
						DISTINCT C.CODE, 
						C.NAME
					FROM 
						mtt_table1 A,
						mtt_table2 B,
						mtt_table3 C,
						mtt_table4 D
					WHERE 1
						AND (C.NAME LIKE '%abc%' OR C.KEYWORDS LIKE '%abc%')
						AND ( SUBSTRING(B.GTIP,1,4)
                              ...
                              See more | Go to post
                              • parabinda
                                started a topic DB2 UDB 9.5 FP2a is not using the best index
                                in DB2

                                DB2 UDB 9.5 FP2a is not using the best index

                                Hi,

                                We are using DB2 UDB 9.5 FP2a.
                                And the following SQL is not using the right index.

                                SELECT a1.col1, a0.col2
                                FROM TABLE1 a0 INNER JOIN TABLE2 a1 ON a0.KEY1
                                = a1.KEY1
                                WHERE ((a0.number_01 = '00001985014082 ') AND (a0.number_02 = '001'))

                                There are indexes on number_01 and number_02 columns.

                                We have done RUNSTATS on the tables.
                                The TABLE1 has -...
                                See more | Go to post
                                Previous 1 2 template Next
                                Working...