| which is faster or any difference [message #8230] |
Tue, 05 August 2003 06:14  |
roblvl
Messages: 27
Registered: June 2003
|
Junior Member |
|
|
hi folks,
i have a table emp
which has the following columns
empno
ename
job
sal
deptno
i have a insert statement like this
1) insert into emp values ('1234','xyz','clerk',null,null);
2) insert into emp (empno,ename,job) values ('1234','xyz','clerk');
which statement is faster
the first or the second
is there any difference
thnks in advance
rob
|
|
|
|
| Re: which is faster or any difference [message #8232 is a reply to message #8230] |
Tue, 05 August 2003 06:52  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi Rob,
there is no significant difference or time difference.
The only thing how to use the second is that you don't need to put in nulls for unused fields.
rgds
Uwe
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
