hi..........i m Accenture employee...Accenture is an IT
company having itz branches in India at Mumbai, Pune,Delhi,
Hyderabad, Chennai and Bangalore....Presently there are
openings here for SAP, Testing, Oracle,Java,.NET,MAinframe
and Peoplesoft...... I am a software engineer working with
Accenture,Mumbai....u can mail me in your resume..i`ll
forward it to our HR team...my mail id:
pankit.lodaya@accenture.com
Answer Posted / srikanth
When we are doing the frequent updates to the columns which
we built the index on the column then the index on that
column is non meaning ful because the index should rebuilt
every time the updation were happen.
we should create index on the columns which we use
frequently in the WHERE clause.
If we dont close the cursor also we do not get any error
the procedure will be executed succesfully but if we close
the cursor the private SQL work area allocated to the
cursor will be relased.
| Is This Answer Correct ? | 17 Yes | 10 No |
Post New Answer View All Answers
how can we know the count/number of elements of an array? : Sql dba
Does pdo prevent sql injection?
what is 'mysqlimport'? : Sql dba
Can I learn sql in a week?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is the current version of sql?
how to fetch alternate records from a table? : Sql dba
define sql delete statement ? : Sql dba
What is a stored procedure in sql with example?
How do I audit the sql sent to the server?
Define tables and fields in a database
Why query optimization is needed?
What is scalar function in sql?
How do I get sql certification?
how mysql optimizes distinct? : Sql dba