1. Getting Column index coderanch.com |
2. when to index column(s) coderanch.comHere is a brief note that I had prepared some time back. Hope it will be useful: Need for Indexes An index placed on a table helps to retrieve data faster. A well placed index makes the application run faster when accessing the data. This is possible because the Database engine looks at the index instead of the column when a ... |
3. MS-SQL - Should i index the column? coderanch.comhello all, I have a Query on MS-SQL server. Consider that i have a table 'Master' and a field 'Name' in the table. If i have a Queru where i use 'Name' in the where clause. There are around 100000 entries in the table & the data is in such a way that almost all entries are repeated around 1000 times. ... |
4. Invalid column index coderanch.comI have written a procedure that returns me Ref cursor. the object that i am returning is a table of records that have two columns. Both the record and the table is created permanently in db. I am calling the procedure from java. The procedure when run separately, gives me two rows with value. Now when i take a result set ... |
5. getIndexInfo , how to get all columns that index applys on them ? coderanch.com |
6. gettting value by column name vs index coderanch.com |
7. Invalid column index coderanch.comMy program is as follows dbStatement.executeUpdate("create table employee(id INTEGER constraint employee_pk primary key not null, " + "name VARCHAR(50), salary float)"); dbStatement.executeUpdate("insert into employee values(1, 'A', 30000)"); dbStatement.executeUpdate("insert into employee values (2, 'B', 50000)"); dbStatement.executeUpdate("insert into employee values (3, 'C', 20000)"); dbStatement.executeUpdate("insert into employee values (4, 'D', 40000)"); PreparedStatement preparedStatement = dbConnection.prepareStatement("update employee set salary = ? where salary <= "); ... |